change a Dialogsheets

[Herb]

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

 

[Jan Karel Pieterse]

Hi Herb,

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.

It should be visible as one of the worksheets in the workbook. If not,
the sheet has been hidden: Format, Sheets, Unhide.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Tom Ogilvy]

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

 

[Gord Dibben]

Herb

Is the workbook in add-in form(*.xla)?

You can change in ThisWorkbook>Properties to Add-in = False

This will allow access to the dialog sheet for editing.

Gord Dibben Excel MVP