editing custom dialog boxes

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

[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

"Shadowrift" <Shadowrift@discussions.microsoft.com> wrote in message
news:ADD595A0-7054-42B2-B74F-768EF49CBE71@microsoft.com...
> 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]

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" <Shadowrift@discussions.microsoft.com> wrote in message
> news:ADD595A0-7054-42B2-B74F-768EF49CBE71@microsoft.com...
> > 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]

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" <Shadowrift@discussions.microsoft.com> wrote in message
> > news:ADD595A0-7054-42B2-B74F-768EF49CBE71@microsoft.com...
> > > 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]

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" <Shadowrift@discussions.microsoft.com> wrote in message
> > > news:ADD595A0-7054-42B2-B74F-768EF49CBE71@microsoft.com...
> > > > 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!
> > > >
> > > >
> > >
> > >
> > >

[Vasant Nanavati]

Try:

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

--

Vasant


"Shadowrift" <Shadowrift@discussions.microsoft.com> wrote in message
news:2609B296-B397-4730-B0A5-916E2B647132@microsoft.com...
> 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" <Shadowrift@discussions.microsoft.com> wrote in message
>> > > news:ADD595A0-7054-42B2-B74F-768EF49CBE71@microsoft.com...
>> > > > 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!
>> > > >
>> > > >
>> > >
>> > >
>> > >