| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show or Hide a worksheet with a macro
I'm trying to hide some specific worksheets in my workbook and in the same
time to show other worksheets, depending of the choise i make. Can anyone help me please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show or Hide a worksheet with a macro
hide: Worksheets("worksheetname").Visible = False unhide: Worksheets("worksheetname").Visible = True Regards, Stefi €˛Hasty€¯ ezt Ć*rta: I'm trying to hide some specific worksheets in my workbook and in the same time to show other worksheets, depending of the choise i make. Can anyone help me please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show or Hide a worksheet with a macro
This is for only one worksheet, but how do i make this for more than one
worksheet "Stefi" wrote: hide: Worksheets("worksheetname").Visible = False unhide: Worksheets("worksheetname").Visible = True Regards, Stefi €˛Hasty€¯ ezt Ć*rta: I'm trying to hide some specific worksheets in my workbook and in the same time to show other worksheets, depending of the choise i make. Can anyone help me please |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show or Hide a worksheet with a macro
Only one by one, e.g. see Help on Visible Property:
For Each sh In Sheets sh.Visible = True Next sh Stefi €˛Hasty€¯ ezt Ć*rta: This is for only one worksheet, but how do i make this for more than one worksheet "Stefi" wrote: hide: Worksheets("worksheetname").Visible = False unhide: Worksheets("worksheetname").Visible = True Regards, Stefi €˛Hasty€¯ ezt Ć*rta: I'm trying to hide some specific worksheets in my workbook and in the same time to show other worksheets, depending of the choise i make. Can anyone help me please |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show or Hide a worksheet with a macro
Thank You! That answered my puzzle
"Stefi" wrote: Only one by one, e.g. see Help on Visible Property: For Each sh In Sheets sh.Visible = True Next sh Stefi €˛Hasty€¯ ezt Ć*rta: This is for only one worksheet, but how do i make this for more than one worksheet "Stefi" wrote: hide: Worksheets("worksheetname").Visible = False unhide: Worksheets("worksheetname").Visible = True Regards, Stefi €˛Hasty€¯ ezt Ć*rta: I'm trying to hide some specific worksheets in my workbook and in the same time to show other worksheets, depending of the choise i make. Can anyone help me please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a macro to open to a specific worksheet | Excel Worksheet Functions | |||
| Editing a simple macro | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Linear Mode
