editing custom dialog boxes
 

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!

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!

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!

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!

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!

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!