Solved

How to list or identify macros in office/visio documents?

Posted on 2009-04-10
1
313 Views
Last Modified: 2012-06-22
I hate Microsoft pop-up messages that warn you about problems but offer no information to help you decide what to do.  A classic example of this is the Security Warning message that pops up when you open a Microsoft Office document that essentially says "This file contains Macros.  Macros may contain Viruses.  It is usually safe to disable macros, but if the macros are litgitimate, you might loose functionallity."  Your options (buttons) are "Enable Macros" or "Disable Macros".  Well, great, there is a button missing here.  The one that says "Click here to see a list of active macros in this document" If I could see a list of the macros, I would then know whether to "Enable" or "Disable" them.   Thanks Microsoft; I don't recall putting any macros in my document, and I don't know if they are ligitimate or not, and I can't figure out how to list or see them.   They're not listed under any of the menu choices.   Anyone have a suggestion?   I hope the solution isn't something very simple, or I'm really going to feel stupid here; but this typical of Microsoft; error messages that don't include a button to google or search the knowledge base.
0
Comment
Question by:meyco
1 Comment
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24115071
meyco said:
>>Anyone have a suggestion?

Yes.  Choose "disable", then hit Alt+F11 to go to the VB Editor, and view the code yourself to get the list of
macros.  If you are satisfied that the macros are OK, close the file, reopen it, and enable this time.

I agree that it would be nice to see a list of macros in that enable/disable dialog, but this is a case where what
may look like a simple request is actually not so simple once you dive into the details :)
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question