Try:

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

--

Vasant


"Shadowrift" wrote in message
...
does anyone know how i can find and edit this dialog sheet??


"Shadowrift" wrote:

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

"Shadowrift" wrote:

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!