macro - workbook on close issue

[jw01]

hello

1)i have a userform that has a command "save/close"
2)in "this workbook" before close, i have asked a timer (macro to be run on a particular) day to popup to remind the user to click on the userform button

problem
it works fine, however, when i click on "save/close" on the userform, .....before the file closes, the msgbox or reminder shows up!

is there a way to stop that from happening, if i select "Save/close"? i realize i have set the settings to, before close msg box, but can anyone help! ive been stuck on this

below is my code, BEFORE CLOSE

Please Login or Register  to view this content.

.....below is my code for "user form"

Please Login or Register  to view this content.

im new with vba so i would really appreciate it if i can get some feedback, thx you. happy new year to all!

[jw01]

basically,

if someone can help me with an "if" statement taht.....if i press "save/close" then do not run the msg box before close....how can i intrigrate that into the code below...pls help

Please Login or Register  to view this content.

[JBeaucaire]

Turn off macro events to suppress other macros from triggering:

Please Login or Register  to view this content.

[jw01]

Thxs J.B.

that resolved my issue, however it prompted another problem. please see code below

Please Login or Register  to view this content.

when i select "yes" from my msg box.....it DOES take me to my sheet, however ....it then prompts or ask me if i would like to save the file....if i say yse, it closes, and if i say no, it still closes.....if i say cancel, then it doesnt do anything......is there a reason why...can someone kindly help!!!