View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Steve Hunter Steve Hunter is offline
external usenet poster
 
Posts: 5
Default 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