Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA: syntax to review macro names in a file?
I frequently use code such as
Dim SheetName For Each SheetName in Sheets .... to perform repetitive actions on all tabs in a workbook. Is there a similar way to review all macros in a workbook? For instance: if I wanted to reset any shortcut keys that may be applied to macros, is there something akin to dim Makroname for each Makroname in Reserved_Word_to_Reference_Macro_List Application.MacroOptions Macro:="'filename.xls'!" & Makroname, Description:="", ShortcutKey:="" Thanks |
#2
|
|||
|
|||
It's my understanding that the shortcut keys assigned to VB macros through
the Excel Macros dialog are only 'seeable' through that dialog and by exporting (File, Export in the VBE) the code of the VB module. For instance a sub named MySub to which I had assigned the shortcut "a" had this 'attribute' in the export: Attribute MySub.VB_ProcData.VB_Invoke_Func = "a\n14" I don't know what the \n14 means. The MacroOptions method only seems useful for assigning shortcuts, etc., not finding them. And, of course, any shortcuts assigned with OnKey will not show up anywhere. -- Jim wrote in message oups.com... |I frequently use code such as | Dim SheetName | For Each SheetName in Sheets | ... to perform repetitive actions on all tabs in a workbook. Is there | a similar way to review all macros in a workbook? For instance: if I | wanted to reset any shortcut keys that may be applied to macros, is | there something akin to | | dim Makroname | for each Makroname in Reserved_Word_to_Reference_Macro_List | Application.MacroOptions Macro:="'filename.xls'!" & Makroname, | Description:="", ShortcutKey:="" | | Thanks | |
#3
|
|||
|
|||
Thanks, Jim, I'll read up on attributes.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a file in a macro (network) | Excel Discussion (Misc queries) | |||
Macro to save a file as a PDF | Excel Discussion (Misc queries) | |||
How do I create a macro, that references another excel file ??? | Excel Worksheet Functions | |||
macro to save file automaticaly? | Excel Discussion (Misc queries) | |||
How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) |