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
Bookmarks