Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide worksheet when moving back to another sheet
Hello,
I have a sheet called 'calculations' that I want normally to be hidden. However, there is a button on one of the sheet (called 'inputs') for the users who are interested in detail to unhide it and see it. Sub Reveal() With ThisWorkbook If Worksheets("Calculations").Visible = False Then Worksheets("Calculations").Visible = True Worksheets("Calculations").Activate End If End With End Sub I have managed to get this working by using this forum. Now, I would like to have a code that hides the sheet 'calculations' again when the users return to the 'inputs'. I was going to have a button for the users to use. As I am not very good with macros, I'd be grateful if someone could help me. Thanks very much in advance! -- Johanna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide worksheet when moving back to another sheet
Sub Macro2()
Sheets("Inputs").Activate Sheets("Calculations").Visible = False End Sub -- Jacob "Johanna Gronlund" wrote: Hello, I have a sheet called 'calculations' that I want normally to be hidden. However, there is a button on one of the sheet (called 'inputs') for the users who are interested in detail to unhide it and see it. Sub Reveal() With ThisWorkbook If Worksheets("Calculations").Visible = False Then Worksheets("Calculations").Visible = True Worksheets("Calculations").Activate End If End With End Sub I have managed to get this working by using this forum. Now, I would like to have a code that hides the sheet 'calculations' again when the users return to the 'inputs'. I was going to have a button for the users to use. As I am not very good with macros, I'd be grateful if someone could help me. Thanks very much in advance! -- Johanna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving back to prior tab | Excel Discussion (Misc queries) | |||
adding worksheet with macro but need to get back to 1st sheet | Excel Programming | |||
Moving Cursor & Sheet back to the Original Location | Excel Programming | |||
How do I hide columns using a button that slides back and forth | Excel Worksheet Functions |