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

  • Thread starter Thread starter Ash Baw
  • Start date Start date
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.
 
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.
Click to expand...

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
 
Back
Top