I have a problem with duplicate shortcut keys, and I was wondering if anyone
knew any way around this. I have developed some personal macros that I use
control + a, d, or r to activate and these macros are stored on the
Personal.xls spreadsheet because I use them all the time. However, I have
just started working with a worksheet developed by a co-worker which uses all
of these keys as macros within the spreadsheet. From what I have read, the
first spreadsheet opened when there is a duplication of shortcut keys has the
priority, and since the Personal.xls spreadsheet is always first, my
shortcuts will always be called.

Since macros are supposed to make things easier, I was wondering if there is
an easy way to work around this conflict. Aside from redefining the shortcut
keys (which really isn't an option), the only way I can think of around this
is to unhide the personal.xls spreadsheet and close it everytime I need to
run one of the new spreadsheet macros. This seems like an simple annoyance,
but before I resign myself to this, is there any other way of getting around
this? I would hope for some kind of option like giving priority to specific
macros, but I haven't found anything like it.

Thanks for any information.