excel macros

[Kevin]

Every time I start this one excel workbook a dialog box
pops up and ask if I want to run or disable the macros.
To my knowledge there is no macro in this particular
workbook. How can I find out if there is one and then
delete it so this pop up doesn't happen.

 

[pfsardella]

Debra Dalgleish has a tidy explanation of what's probably happening
with this workbook.

Alt-F11 will get you into the VBE. Herinstructions should remove any
code remnants.

http://www.contextures.com/xlfaqMac.html#NoMacros

HTH
Paul

 

[Tim Otero]

Hit Alt+F11. This will bring up the Visual Basic Editor. Find the project
with the name of your workbook, open it and look for a folder named
"Modules." In order to clear the message you are getting on opening, the
"modules" folder needs to be emptied and deleted. You may want to open any
modules first to see if there is any code in them, to see what they are
doing.

tim

 

[Ken Wright]

You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you need to search for
your workbook's name, and when you find it you may need to click on the + to expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets above as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question re exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the file.

If that doesn't fix it, then you may have macro code in the Sheet modules, or the ThisWorkbook
module. You need to doubleclick each of them above, delete any code you may find, then hit File /
Close and return to Microsoft Excel and save the file. Good advice given earlier in that if you
delete any code without knowing what it is, you may well be deleting a necessary part of the file.
If you find any code, but are not sure what it does, then simply copy and paste it into a post to
the group and we'll do our best to let you know what it is doing.