Solved

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

Posted on 2009-04-10
1
309 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now