View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default change a Dialogsheets

for each sh in Thisworkbook.dialogSheets
sh.visible = xlSheetVisible
Next

--
Regards,
Tom Ogilvy

Herb wrote in message
...
I am supporting an Excel app that was written many years
ago. It uses a Dialogsheet to get input from the user.

How can I get access to this dialog sheet in Excel 97 or
2000 so I can make a small change on the sheet itself
and/or to figure out what buttons on the sheet belong to
what code.


......thanks in advance.........Herb