Thanks for replying Michael,

It is possible that this sheet might date back to an instance of excel 95 in
the beginning. However, I am unsure how to locate the "dialog box sheet
tab". I have 8 worksheets that are plain excel, but no dialog box sheet at
the bottom that i can see.

Is it possible this sheet is hidden? if not, how and where do i access the
invisible user forms (dialog boxes) ?

Thanks



"Michael R Middleton" wrote:

Shadowrift -

Mayabe they are dialog boxes (Excel 95 and earlier) instead of user forms
(Excel 97 and later). If so, they appear on a dialog box sheet tab, which is
in Excel (along with other worksheet tabs). The older dialog boxes are not
viewable in the VBA Visual Basic Editor.

- Mike
www.mikemiddleton.com

"Shadowrift" wrote in message
...
Hi,

Im updating an excel sheet to incorporate some business changes. The
problem is, i can edit the sheet and the code, but i cannot edit the
dialog
boxes. Can someone explain how to bring up a dialog box explorer? or
editor?

I see in the code there are instances of CustomDialogBoxName.Show

So the objects must be hidden in excel somehow. I need to incorporate
changes to them and if anyone can give me some help it will be much
appreciated!