View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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