Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Worksheet
Is there a way I can hide a worksheet once I click off it, once I click on
any other worksheet. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Worksheet
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Deactivate() Me.Visible = xlSheetHidden End Sub If this post helps click Yes --------------- Jacob Skaria "James" wrote: Is there a way I can hide a worksheet once I click off it, once I click on any other worksheet. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Worksheet
thanks, worked great
"Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Deactivate() Me.Visible = xlSheetHidden End Sub If this post helps click Yes --------------- Jacob Skaria "James" wrote: Is there a way I can hide a worksheet once I click off it, once I click on any other worksheet. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide worksheet tab | Excel Programming | |||
Hide worksheet | Excel Worksheet Functions | |||
VBA to show or hide columns in one worksheet conditioned on value in other worksheet | Excel Programming | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Hide Worksheet | Excel Programming |