Personal Macro file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

--
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.
| --
| Mickey
 
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?
 
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>

--
Jim
| 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?
| --
| Mickey
|
|
| "Jim Rech" wrote:
|
| > 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.
| >
| > --
| > 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.
| > | --
| > | Mickey
| >
| >
| >
 
Back
Top