Changing shortcut keys on macros

  • Thread starter Thread starter WayneB
  • Start date Start date
W

WayneB

Hi: I have a bunch of macros that have old ctl+ shortcut keys that need to
be changed and/or deleted. But I can't find a clue in the VBA code. any
ideas? wayne
 
I don't know about a VBA method, but you can change/delete the shortcut key
in a macro by going to Tools|Macro|Macros|Options

Ian
 
Take a look at application.macrooptoins in VBA's help:

Application.MacroOptions Macro:="myMacro", _
HasShortcutKey:=True, ShortcutKey:="U"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros will not run with shortcut keys 2
macro shortcut help 1
alt down arrow shortcut not working 0
Ctrl V paste coding was lost 1
keyboard shortcut for a macro 3
Limiting the scope of macros and associated shortcut keys 2
Cannot get shortcut keys working on batch files 11
Shortcut key to copy to left 2

Back
Top