Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing macros Dudley Excel Discussion (Misc queries) 9 January 20th 09 01:41 PM
Viewing/Editing/Error Checking KB shortcuts assigned to macros Conan Kelly Excel Programming 1 April 10th 08 12:39 AM
viewing a header/footer while editing evecorin Excel Discussion (Misc queries) 2 April 5th 05 12:32 AM
Protect macro code from viewing/editing Keith[_8_] Excel Programming 5 October 30th 03 02:59 PM
Suspend viewing of macros Steve B[_2_] Excel Programming 0 July 24th 03 02:16 PM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"