Shared Workbook - macro

[Mel L]

I have a macro that saves data from one sheet to a shared workbook. Everything works great, but I get a pop up letting me know it's a shared workbook, etc and requires that I hit save. I want to add to my macro to automatically hit this save, so the user doesn't have to. Is there a simple piece of code I can add to my code to accomplish this?

 

[QuietRiot]

activeworkbook.save false

 

[Mel L]

How will that work? I do want it to save. I already have code to save it. I want the code to override the message box that pops up when you save a shared workbook.

Caution: You are attempting to save a shared workbook that is also protected with a password. Portions of the file, including the change history, will not be encrypted. To help ensure the security of your file, unshare the workbook or delete the change history from you document. Do you want to save this file?

You then have the option of hitting save or cancel. I want it to save.

 

[VoG]

Try

Application.DisplayAlerts = False

before the save then set it to True afterwards.

 

[QuietRiot]

the flase part after activeworkbook.save should do the same thing.

activeworkbook.save false


does that not work for this?

 

[Mel L]

VoG II,
Perfect thanks.

QuietRiot,
I couldn't get it to work.

Thanks for all the help. It is greatly appreciated.