If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Macro disable/enable message appears but no macros in workbook

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-31-04, 14:12
Todd Barkus Todd Barkus is offline
Registered User
 
Join Date: Nov 2003
Location: down on the cube farm, left then right then another left
Posts: 467
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".
Reply With Quote
  #2 (permalink)  
Old 01-01-05, 09:40
savbill savbill is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 01-03-05, 08:33
Todd Barkus Todd Barkus is offline
Registered User
 
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".
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On