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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save BeforeClose 1
application.displayalerts 3
Save failing 2
Exclusive Access 3
2003 created Workbook casuses error when macro runs in 2007 2
Shared Workbook Crash 0
Easiest way to Debug Code 4
save and exit macro 8

Back
Top