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.

That's the code:

Please Login or Register  to view this content.

Somebody knows how to put an if-clause based on the outcome of the Application.Dialogs(xlDialogSaveAs).Show "Holiday_Planner_Copy_NonReadOnly" ?

Thank you