Quote Originally Posted by Hack
What is: saveasUI?

Is that a variable I need to declare or Excel will yell at me?
Its from the BeforeSave event. Set it depending on if you want the Save As dialog box to be displayed or not
Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    '
End Sub