+ Reply to Thread
Results 1 to 2 of 2

Very basic question: getting rid of all evidence of a macro

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003 and 2010
    Posts
    1

    Very basic question: getting rid of all evidence of a macro

    I'm working in an office that uses both Excel 2010 and Excel 2003 (don't ask me why) and there's a spreadsheet I'm working in that someone else created in Excel 2003 which won't let me save changes unless I edit it using Excel 2003. There are a lot of hyperlinks in this spreadsheet which were making it look cluttered and ugly, and since Excel 2003 doesn't have an automatic "remove hyperlinks" feature, I used Google to find this page.

    I wrote the macro as per the instructions on the page, and it ran just fine. Now, however, every time I open the file, I get a message saying that the sheet has DANGEROUS MACROS OH NO and am I really sure I want to open it. I went in to the VBA and removed the module I'd added, but I still get the message. This is only a minor annoyance, but it is an annoyance, and though I'm sure the answer to getting rid of it is fairly simple, I don't know what it is. Can anyone help me out?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Very basic question: getting rid of all evidence of a macro

    Remove the module that contained the macro
    Gary's Student

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1