Sharing violation

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
 
B

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.
 
G

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
 
Top