Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a group of macros for my workgroup and created a table for
each user within the file that enables them to assign their own preferred hotkeys by simply adding the corresponding letter. An Auto_Open macro determines the username, and assigns the hotkeys according to their table. My motivation for this strategy was to avoid maintaining multiple files to preserve each user's idiosyncratic hotkey assignments, but it has occurred to me that, while an improvement, users will still need to come to me to make changes to their assignments, since, when I add a new macro and post the new version to the network, it will contain all of their previously selected choices, rather than a "live" version they may have edited. Does anyone have a suggestion for how I might "have my cake and eat it too"? Thank you. Sprinks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem in updating all worksheets of a workbook using a macro that calls another macro | Excel Programming | |||
Updating worksheets from another file | Links and Linking in Excel | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
CreateTextFile not updating file | Excel Programming | |||
Saving over an existing file (updating an HTM file) | Excel Programming |