Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink to Same sheet but after that want to hide link sheet
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink to Same sheet but after that want to hide link sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide rows of one sheet based on values in another sheet? | Excel Programming | |||
Hyperlink Help - want to link to diff sheet, looking for name cursoris highlighting | Excel Programming | |||
hyperlink - clicking on hyper link to select cell in another sheet | Excel Worksheet Functions | |||
hyperlink to sheet name where sheet names=cell content | Excel Programming | |||
HYPERLINK link problem in Excel sheet using VC++ | Excel Programming |