LinkBack URL
About LinkBacks
Reply With QuoteYou can open the file as read only
or,
if you want to use some VBA, put
Me.Saved = True
in the BeforeClose event of the workbook.
This is a discussion on Turn off the save changes message box! within the Excel Questions forums, part of the Question Forums category; When I open an excel sheet using a macro. After viewing the sheet, I want to close it, but I ...
Turn off the save changes message box!
When I open an excel sheet using a macro. After viewing the sheet, I want to close it, but I don't want the message box to display itself.
" Do you want to save the changes made to sheet 1?"
Yes, No, Cancel
I want to turn this off. How can do this?
Re: Turn off the save changes message box!
You can open the file as read only
or,
if you want to use some VBA, put
Me.Saved = True
in the BeforeClose event of the workbook.
Re: Turn off the save changes message box!
Thank you for your expertise, Juan. It worked perfectly.
Posting Permissions
Bookmarks