View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Sharing violation

Is the workbook shared? That's probably the first thing I'd check and if
so, turn it off to see if the problem goes away.

"GrantW" wrote:

In a macro to save a workbook I have:
Application.DisplayAlerts = False
ActiveWorkbook.Save

I get a message telling me that the workbook could not be saved due to a
sharing violation.

Is this related to my workbook, or my computer, or an Excel issue?


Thanks in advance
Grant