Cancel "Do you want to save" message - Xtreme Visual Basic Talk

09-28-2005, 08:29 AM

King5555

Junior Contributor

Join Date: Jul 2003

Posts: 336

Cancel "Do you want to save" message

I want to only allow people to save over this document if they hit a button on the worksheet. I did this with the beforesave event and had no problem. The only issue is if they make changes and then just go and close the document. It will ask if they want to save the changes. I tried setting the displayalerts to false but that doesn't seem to work. I also don't want the file to be read only because I want them to be able to save the new values in the document by clicking the button. How can I have it close without asking for a save?

Thanks!

09-28-2005, 08:49 AM

George7a

Saved by Grace

Join Date: Mar 2005

Location: Nazareth

Posts: 1,697

type in the code filed of the workbook following

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Me.Saved = False Then Me.Saved = True
End Sub

Now you won't be prompted each time you close the workbook.
Do not forget to save this change

- George

__________________
Read Matthew 24: 3-14 - sounds familiar?
Escape This - The Best Escape Games Ever! | Games Walkthrough
Technology Videos Angry Birds Star Wars Walkthrough

09-28-2005, 09:35 AM

Mike Rosenblum Mike Rosenblum is offline

Microsoft Excel MVP

Forum Leader
* Guru *

Join Date: Jul 2003

Location: New York, NY, USA

Posts: 7,848

Hey King,

If you acheive what you want, they could make a lot of changes and forget to hit your save button... Then exit and loose all their changes w/o any warnings at all.

Are you sure that you want this? Would they??

If you really don't like the default message, then I would at least give them a chance to save by calling your own "Do you want to save changes?" message followed by your own version of Save (whatever you might be doing differently). I really would give them a chance to not lose all their work...

09-28-2005, 09:52 AM

King5555

Junior Contributor

Join Date: Jul 2003

Posts: 336

I'm definitely putting in my own message, I just wanted to avoid the default. Thanks for the help George; it works great. I'm not sure I quite understand what it's doing though. Is it fooling the document into thinking it was already saved?

09-28-2005, 09:55 AM

italkid

Down...

Retired Moderator
* Expert *

Join Date: Dec 2002

Location: Belgium.

Posts: 6,731

And what in case a user don't want the changes he/she made, for instance because of possible mistakes. In that case people tend to close the file without saving changes and reopen it...

Last edited by italkid; 09-28-2005 at 10:34 AM.