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
|