Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to Cancel a Save or Close Event
I tried that and it did not seem to work. I may have done something wrong but the save/close was executed. Since this code is in the beforesave / beforeclose event, would it not only end that event. How would I send the actual "save" or "close".- sooner2
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to Cancel a Save or Close Event
I need to be able to cancel a Save and Close event. After a user has entered his data on a sheet, I have a beforesave and beforeclose event that validates the entire spreadsheet. If I find errors, I need to be able to stop the save or close from completing. Any suggestions?- sooner2
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
