A tip from Scott:
Windows - Unhide, from the menu, shows the Unhide dialog box for unhiding workbooks. In vba, Application.Dialogs(xlDialogUnhide).Show gets the job done.
Where it gets tricky is unhiding worksheets. Via the menu, Format - Sheets - Unhide In vba, the name of the dialog is not so intuitive.
Application.Dialogs(xlDialogWorkbookUnhide).Show
Poorly named, for sure, but you’ve been warned. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/08/12/showing-hidden-sheet-and-workbooks-dialog-in-vba/
Posted
Aug 12 2010, 07:30 AM
by
Daily Dose of Excel