Help deleting embedded Macro reference

  • Thread starter Thread starter Treeskier
  • Start date Start date
T

Treeskier

I built a spreadsheet using a preexisting spreadsheet as a base. The
base spreadsheet may have had a macro at some time as the new
spreadsheet now gives me the "spreadsheet contains macros" warning. I
can't find any embedded macro however. I can find no reference to a
macro in the macro editor. I can find no code in the VB editor. There
is no hidden workbook. There are no ActiveX controls. There is one
list box from the forms control toolbar that has been copied about ten
times but The control remains functional when the macros are disabled.


I would like to delete the problem rather than just get around it by
changing the security setting.

Any help would be appreciated


Thanks
 
Hi Treeskier

Go into the VBE and from the "Project Explorer" ensure there are no
Modules. If there are, delete them. Also, while in the VBE double click
each Worksheet and "ThisWorkbook" to ensure these are empty.



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Same advice, but in case you are not used to the VBE

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.
 
Thank You very much gentlemen...that got me most of the way and I got the
rest...thanks again!
Tim
 
Back
Top