Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
After creating several dozen macros for our workgroup, the issue has come up
that, as we all work differently, using some macros more than others, we have differently preferences for which hotkeys are assigned to them. While each user is free to customize the hotkey settings himself, I'd like to spare them the trouble after each update. Moreover, on the custom menu that loads with the macro sheet, the hotkey assignments are listed next to the menu choices to assist learning. I'd like to set up a table on the sheet where each user can quickly customize his choices rather than dealing with the Macro, Options, set key function. I would read the table on loading, and set the hotkey and menu choices programmatically. Does anyone know how to do this? Thanks. Sprinks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel2007 hotkey | New Users to Excel | |||
WhatsThisHelp in VBA - setting the help file path programmatically | Excel Programming | |||
Setting "DisplayGridlines" Programmatically | Excel Programming | |||
Setting Printer Options Programmatically | Excel Programming | |||
Alt + Enter hotkey - what does this do? | Excel Programming |