-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules