MrExcel.com - Your One Stop for Excel Tips & Solutions

VBA to run/ show an old-style dialog sheet not a VBA userform

Posted by Daniel Cremin on December 13, 2001 11:25 PM

Hi i need the line of code that activates or runs an
excel dialog sheet (not a VBA based user-form but an
actual excel based dialog sheet (excel 95 type).

Posted by Aegeon on December 14, 2001 2:56 AM

ThisWorkbook.DialogSheets("Dialog1").Show