View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Personal.xls ?Save? on exit but no changes

Comment any open event code that modifies the file in some way.

Look for and disable any cell formulas (or named formulas) that include
=Today() or =Now()

Links?

Regards,
Peter T


"Diddy" wrote in message
...
Hi,

I use my Personal.xls to save handy formulas, tips etc. Sometimes if I've
used a piece of code shared on the internet, I'll save the blurb to an
Excel
sheet in Personal.

Recently I get a dialogue box asking if I want to save Personal every time
I
exit Excel even when I know I haven't made changes. I've checked this by
opening a new wkbk and closing immediately.

I did rename Personal a little while ago and saved in another directory
because I wondered if it was slowing the loading of Excel on my machine.
It
wasn't so I deleted the Personal in XLSTART and copied the original
Personal
back in and renamed it.

If anyone can help I would be grateful :-)

Cheers
Diddy