Keyboard Shortcut in Macro

[Guest]

Hi all
i'v created macro with Keyboard Shortcut Ctrl+b . now i want to change it to
Ctrl+z
how can i do it .

regards

 

[Anne Troy]

Tools-->Macro-->Macros. Select (don't open!) your macro, and hit the Options
button.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Guest]

THE MACRO IS NOT APPARING SINCE I SAVE THE EXCEL FILE AS TEMPLETE

 

[Bob Phillips]

So open the template file and do it there.

--

HTH

RP
(remove nothere from the email address if mailing direct)