The code looks like if the file is saved it adds a note in A1000 "saved"
then hides sheets for when it next opens
then deletes the note in A1000 and asks to save again.
Can we just test if the file is saved on close and prompt if it's not
and allow the close if it is already saved?
If we get ride of the helper cell note and just test for the file state as saved or not and prompt for save or allow the close.
The main thing that needs to happen is the sheets other than "prompt" get hidden on close, and on open the user only gets acces to the prompt sheet if the macros are disabled, and the prompt hides and all else unhide when macros are enabled...