DialogSheets("dialog1").Show

Except for a few people (Harald Staff, <vbg) (and support for existing
workbooks), dialogsheets have been (mostly) replaced by userforms (since xl97).

If you want to use userforms, you may want to read Debra Dalgleish's notes:
http://contextures.com/xlUserForm01.html



Dave F wrote:

So I managed to create a spiffy dialog box which has a bunch of buttons which
run a bunch of macros.

But the dialog box is stuck in a tab called Dialog1.

How do I get the damned thing to show up in a regular tab?
--
Brevity is the soul of wit.

--

Dave Peterson