LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default a list of all macros and their key combinations?

This is my second try at getting an answer to a seemingly simple question:

How to list, using a VBA code or even a macro, all the custom key
combinations and their corresponding macros which are active in the currently
open spreadsheets? The list should take into account the selection made in
the 'Macros in:' box, such as This workbook, All open workbooks or
Personal.xls.

I'd like to see which key combinations are still for the taking (instead of
the trial-and-error method I use now or having to go through all the active
macros one by one and checking under Options which key compination runs it,
to see which Ctrl-Shift-letter combinations I can still use...)

z.entropic
 
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
Can excel list combinations BOJO Excel Worksheet Functions 1 July 26th 07 12:26 AM
Can excel list the possible combinations from a range of cells Syndrome Excel Worksheet Functions 6 September 9th 06 09:00 AM
List combinations of a range Steve-in-austin Excel Discussion (Misc queries) 6 May 19th 06 07:37 PM
Need combinations of values from a list to add up to a specific Va GUY Excel Worksheet Functions 0 August 11th 05 11:40 AM
macros - Find a list util Excel Discussion (Misc queries) 1 May 4th 05 03:21 PM


All times are GMT +1. The time now is 04:30 AM.

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

About Us

"It's about Microsoft Excel"