Personal Macro file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikey - 30 Jul 2007 17:12 GMT

How do I stop my Personal Macro file from requesting to be Saved each time I
exit Excel? This is very annoying and has just started happening after
creating some macros to update data from certain clients.

Signature

Mickey

Reply to this Message

Jim Rech - 30 Jul 2007 18:58 GMT

If you put this is a standard module you will no longer be prompted to save
changes:

Sub Auto_Close()
ThisWorkbook.Saved = True
End Sub

Or alternatively, this in the ThisWorkbook module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Saved = True
End Sub

Of course, when you do need to save changes, you must remember on your own.

Signature

Jim

| How do I stop my Personal Macro file from requesting to be Saved each time I
| exit Excel? This is very annoying and has just started happening after
| creating some macros to update data from certain clients.

Reply to this Message

Mikey - 30 Jul 2007 19:34 GMT

Jim
I used the Standard Module in the Personal Macro Workbook and added the code
you advised. It still asks me if I want to Save the changes to the file when
I close Excel. It happens when no other files are open as well. Suggestions?

Signature

Mickey

> If you put this is a standard module you will no longer be prompted to save
> changes:
[quoted text clipped - 15 lines]
> | exit Excel? This is very annoying and has just started happening after
> | creating some macros to update data from certain clients.

Reply to this Message

Jim Rech - 30 Jul 2007 19:55 GMT

I have the same code in my Personal and it works unfailingly. I hope you
copied/pasted my code in rather than retyped it and made a typo like
forgetting the underscore in Auto_Close. Also, you did of course save your
Personal after adding my code?<g>

Signature

Jim

| Jim
| I used the Standard Module in the Personal Macro Workbook and added the code
[quoted text clipped - 20 lines]
| > | exit Excel? This is very annoying and has just started happening after
| > | creating some macros to update data from certain clients.

Reply to this Message

Mikey - 30 Jul 2007 20:10 GMT

I had Auto_Save instead of Auto_Close. Works fine now. Thanks

Signature

Mickey

> I have the same code in my Personal and it works unfailingly. I hope you
> copied/pasted my code in rather than retyped it and made a typo like
[quoted text clipped - 32 lines]
> after
> | > | creating some macros to update data from certain clients.

Reply to this Message

Rate this thread: