Keyboard Shortcut in Macro

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

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

"osaka78" <osaka78@discussions.microsoft.com> wrote in message
news:1721A458-212D-4446-8209-494A459EE428@microsoft.com...
> 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

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

"Anne Troy" wrote:

> Tools-->Macro-->Macros. Select (don't open!) your macro, and hit the Options
> button.
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
>
> "osaka78" <osaka78@discussions.microsoft.com> wrote in message
> news:1721A458-212D-4446-8209-494A459EE428@microsoft.com...
> > 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
>
>
>

So open the template file and do it there.

--

HTH

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


"osaka78" <osaka78@discussions.microsoft.com> wrote in message
news:BB7D19AC-F561-45F2-AAA0-C195B6957EAA@microsoft.com...
> THE MACRO IS NOT APPARING SINCE I SAVE THE EXCEL FILE AS TEMPLETE
>
> "Anne Troy" wrote:
>
> > Tools-->Macro-->Macros. Select (don't open!) your macro, and hit the
Options
> > button.
> > ************
> > Hope it helps!
> > Anne Troy
> > www.OfficeArticles.com
> >
> > "osaka78" <osaka78@discussions.microsoft.com> wrote in message
> > news:1721A458-212D-4446-8209-494A459EE428@microsoft.com...
> > > 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
> >
> >
> >