Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-04-10
1
Medium Priority
?
328 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
New style of hardware planning for Microsoft Exchange server.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

688 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