I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew

wrote:
I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew



1) Go to: Tools Macro Macros
2) Select the macro you want to call
3) Click on Options
4) For Shortcut key, enter a capital V

Bill

highlight the macro in Tools=Macro=Macros and click on the Options button.
In the dialog you can set the shortcut key. Put in an uppercase V.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I would like to use a keyboard shortcut to trigger my macro:
Ctrl. + Shift + V.

Is this possible?

Matthew

Very nice!

For future reference, is there a way to do Ctrl. + Alt. + V?

Matthew

Use a macro to redefine that combination to associate it with your macro.

See the excel VBA help on ONKEY

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Very nice!

For future reference, is there a way to do Ctrl. + Alt. + V?

Matthew

Cool.

Thanks a bunch!

Matthew