Hi All.
I would like to avoid user to SAVE or SAVE AS file. In my macro I used code to disable SAVE and SAVE AS from FILE menu. But how to avoid to save file if user use CTRL+S command to save file?
Thanks.
Hi All.
I would like to avoid user to SAVE or SAVE AS file. In my macro I used code to disable SAVE and SAVE AS from FILE menu. But how to avoid to save file if user use CTRL+S command to save file?
Thanks.
Last edited by eugz; 04-30-2009 at 12:18 PM.
In "ThisWorksheet" use the following code
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
You might add
to that so the user doesn't keep getting prompted to save on exit.Please Login or Register to view this content.
And as a courtesy, also add something to tell the user what's going on:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks Dave. It is works. But I'm thinking user will confused when will try close file and get message: "Do you want to save the changes you made "filename.xls"?" User try to click YES button and message will on screen. How to avoid save file and avoid pop up message also?
Thanks.
You'll need to incorperate
into your code to avoid the warning when closing.Please Login or Register to view this content.
I insert this code to ThisWorkbookBut message still pop up. What I did wrong?Please Login or Register to view this content.
Thanks.
There is no Close event
Please Login or Register to view this content.
Thanks a lot everyone. It is exactly what I want to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks