Can't Find Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been messing around with check boxes and Visual Basic in my Control
Toolbox. Somehow I've managed to imbed a macros in my workbook and am
getting the warning message each time the file is opened. I can't seem to
find the macros to delete it. I have 29 worksheets, so it's not an easy
task. When I open my macros, there shows none. How can I find this and
delete it?
 
ALT + F11 to get to the Visual Basic Editor.

Check for empty modules in your workbook.

These, even though empty, must be removed.

Check for Forms and delete.

Also have a look through the sheets and Thisworkbook for code.

Delete any lines that may be present.

More on this at Debra Dalgeish's site.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB prompts for Password when 'View Code' selected, r-click on tab 7
Macro problem 1
Eliminate macro warning when you open a workbook 1
Run Macros in a Password-protected workbook? 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro warning despite no macros in document 1
Unhide macro worksheet 2
'Cannot insert object' message when I try to put a button on a worksheet 7

Back
Top