Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
Hi -
I am using Excel 2003 SP2 and just created a personal macro workbook. The workbook is saved in the XLSTART folder. Everytime I close Excel, it prompts me to save the workbook. Is there anyway I can stop this from happening everytime I close Excel? I searched previous postings on this subject and the few things I found did not work. Any help would be greatly appreciated. Thanks, Stephen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
Maybe you have a formula in the workbook that 'dirtied' it, such as TODAY()
or the like. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ps.com... Hi - I am using Excel 2003 SP2 and just created a personal macro workbook. The workbook is saved in the XLSTART folder. Everytime I close Excel, it prompts me to save the workbook. Is there anyway I can stop this from happening everytime I close Excel? I searched previous postings on this subject and the few things I found did not work. Any help would be greatly appreciated. Thanks, Stephen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
On Oct 7, 1:29 am, "Bob Phillips" wrote:
Maybe you have a formula in the workbook that 'dirtied' it, such as TODAY() or the like. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ps.com... Hi - I am using Excel 2003 SP2 and just created a personal macro workbook. The workbook is saved in the XLSTART folder. Everytime I close Excel, it prompts me to save the workbook. Is there anyway I can stop this from happening everytime I close Excel? I searched previous postings on this subject and the few things I found did not work. Any help would be greatly appreciated. Thanks, Stephen- Hide quoted text - - Show quoted text - Thanks for the suggestion. I do not have any formulas like that. As a test, I removed by personal macro file and created a new one with one simple macro (no formulas) and had the same result. Any other ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
Does it open unhidden and you set it to hidden?
That will give you the prompt. Gord Dibben MS Excel MVP On Mon, 08 Oct 2007 18:00:52 -0700, wrote: Thanks for the suggestion. I do not have any formulas like that. As a test, I removed by personal macro file and created a new one with one simple macro (no formulas) and had the same result. Any other ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
On Oct 8, 7:26 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Does it open unhidden and you set it to hidden? That will give you the prompt. Gord Dibben MS Excel MVP On Mon, 08 Oct 2007 18:00:52 -0700, wrote: Thanks for the suggestion. I do not have any formulas like that. As a test, I removed by personal macro file and created a new one with one simple macro (no formulas) and had the same result. Any other ideas?- Hide quoted text - - Show quoted text - No, the file opens hidden and I try to close it the same way. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
Hi -
I was wondering if anyone else has any suggestions for my issue below. I've tried the suggestions so far without any luck. I am using Excel 2003 SP2 and just created a personal macro workbook. The workbook is saved in the XLSTART folder. Everytime I close Excel, it prompts me to save the workbook. Is there anyway I can stop this from happening everytime I close Excel? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing Excel with Personal Macro Workbook
I'm having the exact same problem.....any ideas out there?
Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set macro to run automatically when closing workbook? | Excel Discussion (Misc queries) | |||
missing the personal macro workbook option in excel? | Excel Discussion (Misc queries) | |||
CLosing Excel 2007 with personal macro workbook | Excel Discussion (Misc queries) | |||
Personal MAcro workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) |