Validation data on exit Excel or save
in the ThisWorkbook module, there are event handlers for Before Save and
Before close. Both of these have arguments which if you set them to false
will cancel the save or the close. Be very careful with this kind of code
however because users get very frustrated when they can not save their work
or exit the program. If it is 5 o'clock and time to go home but they are only
half way done then what are they supposed to do. You are better off to use a
message box to let them know that the spreadsheet is not complete and then
prompt them if they wish to continue saving or exiting.
--
HTH...
Jim Thomlinson
"Atram Informatika" wrote:
How can I validate data when i exit excel aplication or when i save
workbook?
If data not valid then i must display message and do not exit aplication, or
save document.
Thank's
|