change a Dialogsheets

  • Thread starter Thread starter Herb
  • Start date Start date
H

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
 
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.
Click to expand...

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
 
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
 
Back
Top