editing custom dialog boxes

[Guest]

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!

 

[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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

does anyone know how i can find and edit this dialog sheet??

 

[Vasant Nanavati]

Try:

Format | Sheet | Unhide and see if a dialog sheet is listed.