View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robertguy
 
Posts: n/a
Default 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