Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listing macros associated with shortcut keys
Associated with an Excel95 spreadsheet are numerous macros, many of
which have short-cut keys assigned. I've been negligent of keeping track of which keys are assigned to which macros as I've added to the visual basic code over the years. Every once in a while I hit the wrong combination of keys, and an unknown macro quickly runs. I need to know which macro is running, so I can make sure it is not contaminating the data. Is there any way to quickly view a list of all the assigned shortcuts and the macros that are assigned to them in either Excel95 or Excel97? Alternatively, is there a way to trigger the step-by-step operation of a keyboard macro by entering a keyboard key combination? I know I can do the reverse, but stepping through at least 100 macros is not something I'd like to do. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listing macros associated with shortcut keys
I don't think there is any way to get a list of the custom
keyboard shortcuts. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "windsurferLA" wrote in message ... Associated with an Excel95 spreadsheet are numerous macros, many of which have short-cut keys assigned. I've been negligent of keeping track of which keys are assigned to which macros as I've added to the visual basic code over the years. Every once in a while I hit the wrong combination of keys, and an unknown macro quickly runs. I need to know which macro is running, so I can make sure it is not contaminating the data. Is there any way to quickly view a list of all the assigned shortcuts and the macros that are assigned to them in either Excel95 or Excel97? Alternatively, is there a way to trigger the step-by-step operation of a keyboard macro by entering a keyboard key combination? I know I can do the reverse, but stepping through at least 100 macros is not something I'd like to do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros will not run with shortcut keys | Excel Worksheet Functions | |||
macros shortcut keys don't work | New Users to Excel | |||
Macros Shortcut keys | Setting up and Configuration of Excel | |||
Shortcut keys assigned to macros/functions in excel | Excel Worksheet Functions | |||
Changing shortcut keys on macros | Excel Worksheet Functions |