editing custom dialog boxes

S

Shadowrift

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!
 
M

Michael R Middleton

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
 
S

Shadowrift

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
 
S

Shadowrift

the vba code is as follows:
Sub ShowProjectDescriptionDlg()
With ActiveWorkbook.DialogSheets("dlgProjectDescription")
.Show
End With
End Sub

-the button calls a macro ShowProjectDescriptionDlg()
-a dialog box is then displayed
 
Top