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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >