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

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
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
excel2007 hotkey L@ja New Users to Excel 0 January 29th 08 12:23 PM
WhatsThisHelp in VBA - setting the help file path programmatically seisman Excel Programming 2 July 29th 05 03:06 PM
Setting "DisplayGridlines" Programmatically Chaplain Doug Excel Programming 3 March 23rd 05 03:53 PM
Setting Printer Options Programmatically Chaplain Doug Excel Programming 0 December 16th 04 09:35 PM
Alt + Enter hotkey - what does this do? R Avery Excel Programming 2 October 14th 04 05:23 PM


All times are GMT +1. The time now is 12:21 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"