Personal macros file

[B Lynn B]

I keep a number of blocks of code in my personal.xls startup file just to
have them readily at hand and perform routine tasks more quickly (and
sometimes to save bits that were hard to figure out how to do). My company
has chosen a somewhat chaotic approach to transitioning staff/depts from
Excel 2003 to 2007, resulting in my needing to have both application versions
on my PC at the same time. Believe me, I KNOW this is not recommended.

So, here is my question. I've succeeded in creating one personal.xls file
in my startup folder that opens for either application - though in 2007 it
opens in compatibility mode. Can anyone think of a reason this would be a
bad idea? Something I haven't anticipated that will bite me in the ass later?

 

[James Igoe]

Typically you can have a file opened by only one user - in this case one
instance of 2003 or 2007 - but you are likely using a file you've shared. An
alternative to a personal.xla is to create an XLA in 2003, which will load in
either version, and has the benefit of not caring about ownership.