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.
That's the code:
Somebody knows how to put an if-clause based on the outcome of the Application.Dialogs(xlDialogSaveAs).Show "Holiday_Planner_Copy_NonReadOnly" ?
Thank you
Bookmarks