LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 86
Default Custom Hotkey Strategy

We have 50 or so macros, some of which have assigned hotkeys. Others are
available only through a custom menu (thanks, John Walkenbach!). Our boss,
however, prefers different hotkeys than the rest of us, so I created a 2nd
file for him which has different hotkey assignments, as well as different
Descriptions for the custom menu, e.g.,

Round to One Place (Ctrl-r)

I'd rather not maintain two files, however, so I thought of extending the
table that John W.'s code uses, adding columns for "Default HotKeys" and [the
boss' username]. The code could then read the appropriate hotkey assignments
depending on the username.

This strategy breaks down, however, on a laptop or home computer that he
might use that doesn't have the same (if any) username, which would cause the
macros to work differently than he expects.

What I'd like to do is:
- Determine if we're on the corporate network
- if so, use the username
- if not, present the user a combo box to select the hotkey setup

Can anyone point me in the right direction?

Sprinks

 
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
Help creating a summary tab (strategy) Jeremy Excel Discussion (Misc queries) 1 June 5th 08 06:30 PM
Strategy Needed kleivakat Excel Discussion (Misc queries) 2 March 7th 06 09:09 PM
Freeze IDE or other strategy ??? Greg Wilson Excel Programming 2 June 17th 05 06:05 AM
Workbook Switching Strategy Nigel Excel Programming 6 May 5th 05 06:24 PM
Strategy Query Chuckles123[_73_] Excel Programming 0 November 24th 04 04:22 AM


All times are GMT +1. The time now is 07:11 AM.

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"