Thread: Help changing Keyboard Shortcut assigned to Excel Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Help changing Keyboard Shortcut assigned to Excel Macro
Do you mean change through code....Try

Application.MacroOptions Macro:="Macro1", ShortcutKey:="i"

--
Jacob (MVP - Excel)


"Amar" wrote:

Hi,

I don't know visual basic and have created some simple macros by recording
them in excel. I would like to chnage the shortcut keys assigned to the
macros while recording. Is this at all possible?

Tks,
Amar
Reply With QuoteReply With Quote