removing macros

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I removed a couple of macros from a workbook yet everytime
I open the file excell still askes if I want to disable
the macros or not. The computer I'm going to put this
workbook on needs to have it's security setting on med. So
I can't just change that. Is there a way to remove the
macros and excell act like they were never there?

Thanks for the help.
 
Matthew

you need to remove the module(s) in which the macros resided.

Press Alt-F11 to enter the VBE. Right click on each of the modules, select
Remove Module and answer No to the prompt. You may need to check the
Worksheet code modules and the ThisWorkbook code module. Press Ctrl-A and
delete in each one to make sure nothing will remain.

That should do it.

Regards

Trevor
 
You also need to remove the module in the VBA Editor.
Empty or not if the framework is there then it thinks
somethings up and asks.

You probably have a module1 or something in the VBA
Project list. Find and remove the module and all should be
well.

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
 
Back
Top