Solved: Run a dialog using Macro

[dansam]

Hi,
On my workbook I have two items:
(1) Sheet1
(2) Dialog 1

I can run the dialog using the ?run dialog? button from the ?FORMS? toolbar. I want to know that how to run that dialog using a macro?? (Like to show user form we use ?userform1.show?)

Regards,
Dan

[Marcster]

Hi Dansam,

Try this:
[VBA]
DialogSheets("Dialog1").Show
[/VBA]

Marcster.

[dansam]

Hi Marcster,
It just got worked fine.
Thank you very much for kind help.

DAN

[dansam]

And what to do if I want to hide that dialog ??
dan

[Norie]

Dan

A dialog sheet?

They date back to Excel 95 or thereabouts.

I'm pretty sure they've been replaced by userforms.

[dansam]

Oh!!
I didn’t know the matter!
I am just trying to learn that what kind of thing is a dialog sheet !!
But … Thanks for suggestion


Regards,
Dan