View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sprinks Sprinks is offline
external usenet poster
 
Posts: 86
Default Trouble With MacroOptions

I'm trying to test setting the macro hotkey programmatically. The first
attempt is trying to remove the hotkey assignment for a macro named
"RoundOnePlace". The following code runs without error, but does not remove
the hotkey assignment.

Public Sub TestMacroAssign()
Application.MacroOptions Macro:="RoundOnePlace", HasShortcutKey:=False
End Sub

Should I discover what I'm doing wrong, I also need to know:
- What values for ShortcutKey correspond to Ctrl-(letter), and
Ctrl-Shft(letter)
- If there is a Macros collection that I can loop through

Thanks.
Sprinks