Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Macro Hotkeys Programmatically
I've created a library of macros for our small workgroup. All are available
from a custom menu which loads as Excel loads based on some John Walkenbach routines. I maintain the file on a local drive, post changes to a shared network folder, and users use a desktop shortcut to copy the new file to their auto-load folder. The principal of our firm, however, prefers a different hotkey assignment than the rest of us. To avoid having him to customize his configuration each time, I began maintaining two different versions of the macro file. This has, predictably, become more of a maintenance headache than I want to have--life's too short. Can someone tell me how I can read the username on file load and configure hotkey assignments based on each user? I figured that I would use a table on a hidden worksheet to store each user's preferences, as well as a default configuration. Thank you for any assistance. Sprinks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting VBA reference programmatically | Excel Programming | |||
Setting Data Validation Programmatically | Excel Programming | |||
Setting Solver Reference-programmatically | Excel Programming | |||
Setting HotKey Programmatically | Excel Programming | |||
Do macro shortcuts interfere with excel hotkeys? | Excel Discussion (Misc queries) |