| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding All hidden Worksheets with a Macro/VBA Code
Hi, Can anyone help me please ? Whilst working with an Excel Workbook I often hide all unwanted Worksheets leaving only the ones I need to work on visible. What I would like to do is have a macro or VBA code to click on a button to unhide all hidden worksheets rather repeating Format-Sheet-Unhide to unhide each worksheet. Any help would be greatly appreciated (Excel version Excel 2000) Many thanks Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=490133 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding All hidden Worksheets with a Macro/VBA Code
Try this
Dim mySheet As Worksheet For Each mySheet In Worksheets mySheet.Visible = True Next mySheet "robertguy" wrote: Hi, Can anyone help me please ? Whilst working with an Excel Workbook I often hide all unwanted Worksheets leaving only the ones I need to work on visible. What I would like to do is have a macro or VBA code to click on a button to unhide all hidden worksheets rather repeating Format-Sheet-Unhide to unhide each worksheet. Any help would be greatly appreciated (Excel version Excel 2000) Many thanks Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=490133 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhiding All hidden Worksheets with a Macro/VBA Code
It Works Many thanks to bigwheel !! Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=490133 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lost my Paste | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Linear Mode
