Closing Excel with Personal Macro Workbook

[shoey812]

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

 

[Bob Phillips]

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)

 

[shoey812]

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)









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

 

[Gord Dibben]

Does it open unhidden and you set it to hidden?

That will give you the prompt.


Gord Dibben MS Excel MVP

 

[shoey812]

Does it open unhidden and you set it to hidden?

That will give you the prompt.

Gord Dibben MS Excel MVP







- Show quoted text -

No, the file opens hidden and I try to close it the same way.

 

[shoey812]

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?

 

[pilotctk2]

I'm having the exact same problem.....any ideas out there?

Thanks!!