Prevent saving

**LydiasDad** · 07-10-2011, 09:45 PM

When a user exist my workbook, they're prompted to save each time. I don't want them to be prompted; the workbook should never be saved. How can I prevent the message, and how can I disable the File/Save menu option?

**docMed** · 07-11-2011, 01:07 AM

If you search the forums, or even google, this can be found quite easily...

In the future try to do so first, otherwise put this code in your 'ThisWorkbook' module (push alt+f11 to pull open your vba editor, double clik 'thisworkbook' and copy/paste the following code, then save the workbook - follow these steps and you will no longer be prompted to save).

Please Login or Register  to view this content.

You can disable the file save menu by exploring the commandbars feature...

You could do something like...

Please Login or Register  to view this content.

**royUK** · 07-11-2011, 01:20 AM

You can't prevent them saving. All they need to do is open without enabling macros.

Disabling a commandbar on opening will require it to be restored on closing.

**docMed** · 07-11-2011, 01:22 AM

Well, it sounds like the workbooks simply being used to either calculate temporary values, or be viewed for constant information - in this case, just set the workbook to read only, which will work around your source file being accidentally saved at least. And yes, you can disable the commandbar and enable it upon closing if you desire so.

**snb** · 07-11-2011, 03:37 AM

You can 'prevent saving' using the workbook as an AddIn.

Or

Always offer the user a copy of the 'not-to-be-saved' workbook, using

Please Login or Register  to view this content.

If you want to assist the user maximally you'd best use a userform.

**LydiasDad** · 07-11-2011, 02:40 PM

For the code from DocMed, do I post it to the ThisWorkbook under Excel Objects? If so, it's not working. How do I make it execut the code?

If no, where should it go? Sorry, a little new to this. My questions are exceeding my skill level at this point.