Viewing/editing Macros

[Susan]

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]

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