Hyperlink to Same sheet but after that want to hide link sheet

A

Ash Baw

Hello Sir,

I create button on sheet1 and hyperlink this button to open sheet2. after that i hide sheet2 but when i hide sheet2 link nor work. i want to button work after hidding the sheet
can u help me.
 
G

GS

Hello Sir,
I create button on sheet1 and hyperlink this button to open sheet2.
after that i hide sheet2 but when i hide sheet2 link nor work. i want
to button work after hidding the sheet can u help me.

In order to display hidden sheets you need to set their 'Visible'
property...

Sheets("Sheet2").Visible = True

...where I assume you're talking about sheets in a workbook.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top