This code is copied straight from the book Lesson 25 - Using Dialog Sheets
Code:
Set dlgShowMessageOnce = ActiveWorkbook.DialogSheets.Add With dlgShowMessageOnce
This macro won't run because of the following Error Message:
Compile error: Syntax error
Please advise!