Closing the workbook & saving automatically

**mwc0914** · 01-25-2008, 11:39 AM

I have my Excel workbook open & have made changes. Now I close it and Excel prompts me if I want to save the changes. Is there a way to just close the workbook and automatically accept any changes without have the "Do you want to save changes" message appear?

What about if it is opened in read-only mode? Typically the workbook will not save any changes unless you save it off as another file name. If there is a solution to my question above, can it be enabled only when the workbook is opened in edit mode, or will it not auto-save changes over the file because Excel knows it was opened in read-only mode?

**royUK** · 01-25-2008, 11:55 AM

I don't think you can save changes in Read Only.

**davesexcel** · 01-25-2008, 11:57 AM

Once the workbook has been saved you can use this, it goes into the workbook module

Please Login or Register  to view this content.

You can set up the workbook to be read only in the tools options, and then use a password if you want to modify the workbook....

**mwc0914** · 01-25-2008, 12:29 PM

Sorry...the above still displays the "Do you want to save your changes" message when I try to close the workbook.

I tried using the same thisworkbook.saved = true

in the auto_close macro, but it did not save any changes I made to the workbook.

**royUK** · 01-25-2008, 12:44 PM

Try

Please Login or Register  to view this content.

**mwc0914** · 01-25-2008, 01:06 PM

Still get the "Do you want to save your changes" message. If I add

Please Login or Register  to view this content.

to the workbookbeforeclose macro, I still get the message.

Just noticed something...these macros are contained on my sheet object. Do they need to be on my workbook object instead?

**mwc0914** · 01-25-2008, 01:35 PM

Got it working mostly with...

Please Login or Register  to view this content.

When opened in read-only mode, if someone tried to make a change, it closes without saving the changes.

**VBA Noob** · 01-25-2008, 02:43 PM

mwc0914,

Please remember to wrap code next time. See forum rule 5 below to see how to wrap

VBA Noob

**davesexcel** · 01-25-2008, 03:39 PM

I wonder if you have placed the code in the workbook module.....

**royUK** · 01-25-2008, 06:18 PM

You shouldn't get the message with the code i supplied. I think Dave is right, you have put the code in the wrong place see the link in my signature for where to put the code.

Closing the workbook & saving automatically

LinkBack

Thread Tools

Rate This Thread

Display

Closing the workbook & saving automatically

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions