Excel 2003 Macro shortcut keys

[Steve P.]

Hello,
I have had several excel macros working just fine until last week and all of
a sudden the shortcut keys stopped working. I did have a new PC profile
created because Word kept crashing. It is fine now.

For instance, I have a simple macro that shifts data from one column to
another (Ctrl + Shift + S) and another that uses (Ctrl + Shift + L). The
macros will run if I do them manually, but now the shortcut keys just give me
the default Excel behavior, such as font size or column width.

If I change the shortcut letter, the macro works again with key strokes, but
I use so many (and other people use them as well) that it would be a
nightmare. Is there something I can check to find out why this all started
happening?



Thanks in advance.
Steve P.

 

[CyberTaz]

Although someone who can answer the question may eventually come along
you'll most likely get a more prompt response if you post to the appropriate
Windows Excel group - this one is the Mac Excel group. Since the problem may
well be OS related you aren't likely to get a quick answer here. The Win
Office groups can be accessed from:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Hello,
I have had several excel macros working just fine until last week and all of
a sudden the shortcut keys stopped working. I did have a new PC profile
created because Word kept crashing. It is fine now.

For instance, I have a simple macro that shifts data from one column to
another (Ctrl + Shift + S) and another that uses (Ctrl + Shift + L). The
macros will run if I do them manually, but now the shortcut keys just give me
the default Excel behavior, such as font size or column width.

If I change the shortcut letter, the macro works again with key strokes, but
I use so many (and other people use them as well) that it would be a
nightmare. Is there something I can check to find out why this all started
happening?



Thanks in advance.
Steve P.

Not a clue. But, you might get a better response by posting to one of
the Windows Excel forums. This one is For Macintosh Excel.