| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide sheet - Help
Hi all, i have used the following to hide a sheet and need to make it
visable again, could somebody help me out with some code ? worksheets(4).visible = xlSheetVeryHidden Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide sheet - Help
worksheets(4).visible = True
"Les Stout" wrote: Hi all, i have used the following to hide a sheet and need to make it visable again, could somebody help me out with some code ? worksheets(4).visible = xlSheetVeryHidden Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide sheet - Help
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide sheet - Help
Suggest using
= xlSheetVisible instead of = True -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike" wrote in message ... worksheets(4).visible = True "Les Stout" wrote: Hi all, i have used the following to hide a sheet and need to make it visable again, could somebody help me out with some code ? worksheets(4).visible = xlSheetVeryHidden Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide sheet - Help
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Sheet, Hide Sheet | Excel Discussion (Misc queries) | |||
| hide sheet name/ Tab | New Users to Excel | |||
| Hide a Sheet | Excel Programming | |||
| hide sheet tab | Excel Programming | |||
| hide sheet? uncheck sheet tabs? or ??? | Excel Programming | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
