Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Macro disable/enable message appears but no macros in workbook

    When I was doing some research for my question of yesterday (locking one cell) I created some macros. I have deleted those macros but I still get the message that my document contains macros. Anyone know how to shut that off?
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    It may be that although you deleted the Procedures you left the Module in the workbook? Open the VB Editor and show the Object Browser. Select your workbook object and view all the workbook/worksheets to make sure code is removed. If there are any modules or empty modules under the workbook remove those as well. Then save/close and open it again. If the problem persists you may have to copy your data to a new clean workbook and save it fresh.


    /
    ~

    Bill

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Thanks Bill. That was it.
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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