BeforeSave, Cancel and ReadOnly
That does work but it affects all other workbooks open in Excel too, where I
may want to see the alerts.
dq wrote:
I think the simplest solution would be to put the line
Application.Displayalerts = False
in the WorkBook_Open event to surpress the errormessage as the saving
doesn't seem to be a problem
|