Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 86
Default Updating Macro File

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in updating all worksheets of a workbook using a macro that calls another macro [email protected] Excel Programming 3 March 20th 06 05:21 AM
Updating worksheets from another file Sonic Links and Linking in Excel 0 November 2nd 05 06:10 PM
Excel updating from XML file - file path specific? Sean Excel Discussion (Misc queries) 4 August 5th 05 12:56 PM
CreateTextFile not updating file Sean McPoland[_2_] Excel Programming 1 February 4th 04 10:58 PM
Saving over an existing file (updating an HTM file) No Name Excel Programming 2 December 3rd 03 06:19 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"