Macro Shortcut

A

Alex

For the love of god, how do you make a macro shortcut work
in excel 2003??

I go to Tools/Macro/Macros i select the macro i want to
assign a shortcut key to and the click on options, then in
the little shortcut textbox i slect a letter, i.e. q or m, etc.

i then click on ok and cancel then i save the excel file,
i press ctrl+q or ctrl+m,etc., and nothing happens..

no matter what letter i assign as a shortcut it doesn't
work, is there any code i should include in the
initialisation of excel..?

Any help much appreciated,
rgds,
Alex
 
R

Robert Christie

Hi Alex
I don't use xl2003 but the 'cancel' part of your line;
i then click on ok and cancel then i save the excel file
Click to expand...

makes me think you are cancelling what you have just
entered. Usually you OK out of textboxes to close them.

HTH

Bob C.
 
A

Alex

Nope that is unfortunatelly not the case

there seems to be a problem with my macro only as with all
other macros it works impecably..

thanks anyway,
Alex
 
B

Bob Phillips

Does it run if you issue it from the Tools>Macro>Macros menu?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top