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

[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.

 

[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