View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default Bringing up the Unhide Sheet list via macro

Is it possible to bring up the Sheet Unhide window using a macro?
Basically, there may be several sheets that are hidden. I want this macro
to bring up the Sheets Unhide window so that I can then select the sheet
that I want to unhide. When I know the sheet name, I know I can unhide that
sheet with the following:

Sheets("SheetName").Visible = True

But if you don't know the sheet name and you just want to bring up a list,
you would normally have to click on Format-Sheet-Unhide.
Can this been done using a macro?

Thanks,
Paul