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 |
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 |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com