Hi Gordon,

Sub SHOWDIALOG1()
DialogSheets("DIALOG1").Show
End Sub


Silly me. Forget my previous reply. A dialogsheet cannot be shown
modeless, you must use a userform (In the VBE insert, userform) for
that.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com