Herb

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

You can change in ThisWorkbookProperties to Add-in = False

This will allow access to the dialog sheet for editing.

Gord Dibben Excel MVP

On Sun, 25 Jan 2004 19:48:20 +0100, Jan Karel Pieterse
wrote:

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