VBA: Open Save Prompt & execute macros based on user decision (save or cancel the save pro
Hey. I would like to do a check for ReadOnly and then ask the user if he/she wants to save as a new file.
If the answer is no, it will exit sub (should work already).
If the answer is yes, a save prompt will open. Now again I would like to have an If-function that if the user actually does save the file, the macros are called. BUT if the user changes during the save prompt his/her mind, I would like to "Exit Sub" as well.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Bookmarks