Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have put a button on a summary worksheet to go to a 2nd worksheet
and this works fine. However i have now hidden the 2nd worksheet and my simple code will nolonger find it. Can I still use the button (but just amend the code) if the 2nd worksheet is "hidden". Or do I have to unhide the sheet for it to work. This is the simple code that i am using, can it be changed Private Sub CommandButton3_Click() Sheets("BIC code summary").Select End Sub Bob ps I also have another button on the hiden sheet to return to the original sheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
hidden worksheet? | Excel Worksheet Functions | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |