Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |