+ Reply to Thread
Results 1 to 2 of 2

Stuck Excel macro

  1. #1
    Registered User
    Join Date
    10-22-2006
    Posts
    5

    Stuck Excel macro

    I've deleted the macros I was experimenting with but now when I open the spreadsheet I still get the macro warning dialog. There is nothing in the list of macros (Tools/Macro/Macros) and no code showing when I right click on the sheet tab and select View Code. Any ideas?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    After selecting View Code, you are now in VBE. Hit CTRL + R to show the project explorer window. Find your file, then click on the + to expand and show all sheets and modules.

    Most likely there is a Module1 located here, which you must right-click and select Remove.

    Even if you delete all the code from general modules, if the module exists, Excel will generate the security warning.

    HTH

    Jason

+ 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