Disable Save Prompt

**Daeghen** · 03-07-2012, 12:29 PM

Win XP Pro, Version 2002, Service Pack 3

Hello,

A coworker wishes to disable the save prompt when closing Excel 2010, despite my best discouragement. This is accomplished easily with one line of code:

Please Login or Register  to view this content.

When this code is placed in the normal template of Word 2010, it works marvelously for all new and existing Word documents. However, I cannot get it to behave similarly in Excel. Excel apparently does not come with a built-in global template, so "personal.xlsb" must be created in the XLStart folder. Despite my not being able to physically see this file (hidden files viewable), I believe it exists because it shows up in my Visual Basic project explorer. I got it there by "recording" a macro and storing it in "Personal Macro Workbook" per the advice of a web reference. When I place the above code in the "personal" template in the same manner as I did in Word, it does not function for new and existing files.

It may matter that IT has restricted employees from modifying files and folders under "Program Files", therefore I cannot create or save files directly to XLStart.

Thanks for reading,
-Daeghen

**Winon** · 03-07-2012, 12:37 PM

Hello Daeghen,

Try:

Please Login or Register  to view this content.

**royUK** · 03-07-2012, 12:48 PM

Check this

http://office.microsoft.com/en-us/ex...005199391.aspx

**Daeghen** · 03-07-2012, 12:50 PM

Hello Winon,

Thank you for you reply. I have tried that along with "ActiveWorkbook" with no success.

-Daeghen

**Daeghen** · 03-13-2012, 12:34 PM

I've narrowed the problem down to this: The "PERSONAL.XLSB" file exists, and I can store macros in it for use on all XL workbooks. I can actively run those macros from PERSONAL.XLSB on other opened workbooks, but I can't make them run on an event (BeforeClose). The code is stored in the "ThisWorkbook" module of PERSONAL, but it only runs *Before* I *Close* PERSONAL, where I want it to run when I close any other opened workbook.

**shg** · 03-13-2012, 12:49 PM

In the ThisWorkbook module of Personal:

Please Login or Register  to view this content.

This is a really bad idea.

**Daeghen** · 03-14-2012, 08:30 AM

shg - That worked!

I agree that it is a bad idea, and as mentioned earlier I tried to talk my coworker out of it. He did have a decent enough point. His job requires him to generate/download ~100 excel files from a database every day. He runs a quick task on that file, compares it to the database value, then closes the file. It is not necessary for him to save a copy, so the save prompt has evolved to an extreme annoyance.