Excel Still Thinks Workbook Has Macro Code
 

I removed the one function I tested in my workbook, but Excel still
prompts with the VBA security box when I open the file. How do I get
rid of this?

TIA,
Dan

Excel Still Thinks Workbook Has Macro Code
 

Right click on each mod and choose Remove. Then look at the code for
each worksheet and in ThisWorkbook and make sure there is no code in
any of those.

Excel Still Thinks Workbook Has Macro Code
 

by "mod" I mean Module. Also remove any object modules. (All of this
via the Project Explorer in the VBA window )

Excel Still Thinks Workbook Has Macro Code
 

Remove any empty modules
--
Gary's Student


"Dan" wrote:

I removed the one function I tested in my workbook, but Excel still
prompts with the VBA security box when I open the file. How do I get
rid of this?

TIA,
Dan

Excel Still Thinks Workbook Has Macro Code
 

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Dan wrote:

I removed the one function I tested in my workbook, but Excel still
prompts with the VBA security box when I open the file. How do I get
rid of this?

TIA,
Dan

--

Dave Peterson