If I havent changed the file and close, having not made any changes
it won't matter. the sub can run to re-hide..

If changes were made and saved, (or no changes and saved)
then on close the sheets should re-hide and that change should be saved automaticaly without a prompt

If I made a change but haven't saved it and don't want to -
I should be able to close without saving changes - exit sub

I think maybe the note if saved might help this dilema (A1000="saved")
If saved while open we can test for that cell value on close
and run the script if saved or no changes were made,
prompt if changed but not saved - if save declined close not saving
or if save accepted run sub and save...