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

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

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

HTH

Bob C.


-----Original Message-----
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
.

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


-----Original Message-----
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

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

HTH

Bob C.


-----Original Message-----
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
.

.

Does it run if you issue it from the ToolsMacroMacros menu?

--

HTH

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

"Alex" wrote in message
...
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


-----Original Message-----
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

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

HTH

Bob C.


-----Original Message-----
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
.

.