Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Method 'MacroOptions' of object'_Application' failed Runtime Error 1004 | Excel Discussion (Misc queries) | |||
IRR Trouble | Excel Worksheet Functions | |||
MacroOptions Method | Excel Programming | |||
MacroOptions doesn't stick | Excel Programming | |||
still having trouble with this.... | Excel Worksheet Functions |