We help IT Professionals succeed at work.

Save Prompt - Annoying

Rayne
Rayne asked
on
Hello All,

I have a macro - after its done running, it does a  >>

activeworkbook.save to automatically save the book.

Now I also added a line like this:

application.Display Alerts  = False below the workbook save but I keep getting this dialog box  - attached pic

Please assist. I need to get rid of that dialog box and not have it display at all whenever
I do activeworkbook.save in my code
savePrompt.png
Comment
Watch Question

Author

Commented:
Can this be made a general settings where pc doesn't matter, any user who plays with this file, doesn't get the prompt?
I believe yes using Group Policy but then this would only apply to computers on your network. Don't think you can control this on other people's PCs.
Analyst Assistant
CERTIFIED EXPERT
Commented:
Put Application.DisplayAlerts = False before the save.

Author

Commented:
You Rock imnorie :)
Dead on !!!!!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.