ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Viewing/editing Macros (https://www.excelbanter.com/excel-programming/421793-viewing-editing-macros.html)

Susan

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

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