Sharing violation

  • Thread starter Thread starter GrantW
  • Start date Start date
G

GrantW

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
 
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.
 
Barb,
No the file is not shared. I am doing some digging in Microsoft Help at the
moment, seems to be a typical problem to do with registry values. Definietly
a computer / Excel issue.
Thanks for taking the time anyway. regards
Grant
 
Back
Top