Macros

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

Guest

How do I permanently delete a Macro? I do not even want the prompt to display. Is this possible?
 
Hi Tammy!

It might be a good idea to run code found on Chip Pearson's website on
this workbook.

Chip Pearson:
http://www.cpearson.com/excel/vbe.htm
See code under Deleting All VBA Code In A Project

Read the warnings!

A manual approach would be:

Delete all modules, forms, class modules and references
Go to each Excel Object in turn and ensure by using the delete key at
top left of the code sheets that there is absolutely nothing
on those sheets.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Tammy said:
How do I permanently delete a Macro? I do not even want the prompt
Click to expand...
to display. Is this possible?
 
When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions for finding and removing code on the
following page, and a link to Chip Pearson's macro to remove all VBA
code in a workbook:

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