Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing/editing Macros
Hello,
Inherited a spreadsheet. When opening, the macro message appears, enable or disable. How can I find that macro to view or edit without a name? Thank you everyone. Susan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Viewing/editing Macros
that message you are encountering has nothing to do with the actual
macro. it's simply the macro security warning asking you if you want to enable or disable macros in general. it means the macro security is set at medium. you'll have to answer that question in order to be able to get to the VBE (visual basic editor) in which you can see what macros are attached to the document (assuming they are not password protected) and edit them. use Alt+F11 to get to the VBE once you are in the document. hope this helps! :) susan On Dec 29, 1:35*pm, Susan wrote: Hello, Inherited a spreadsheet. *When opening, the macro message appears, enable or disable. *How can I find that macro to view or edit without a name? Thank you everyone. Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing macros | Excel Discussion (Misc queries) | |||
Viewing/Editing/Error Checking KB shortcuts assigned to macros | Excel Programming | |||
viewing a header/footer while editing | Excel Discussion (Misc queries) | |||
Protect macro code from viewing/editing | Excel Programming | |||
Suspend viewing of macros | Excel Programming |