change a Dialogsheets
 

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

change a Dialogsheets
 

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

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

change a Dialogsheets
 

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