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.

"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

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

"Barb Reinhardt" wrote:

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