Hi All, I am using the following code to alert a user that data entry which is required to generate the filename hasn't been made, and when OK is clicked a dialog box appears showing the filename which defaults to '.xls.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...