Sharing violation

[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

 

[Barb Reinhardt]

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]

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