macro warning window
 

-turn off macro warning window when all macros are deleted-
bodyshopman

macro warning window
 

When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of
the worksheets or ThisWorkbook.
--
HTH...

Jim Thomlinson


"Bodyshopman" wrote:


-turn off macro warning window when all macros are deleted-
bodyshopman

macro warning window
 

I've got the same problem.

I've delete every macro and line of VB code I can find in all 12 sheets in
the workbook. I save the workbook and close it. When I re-open the workbook,
I get prompted to enable macros again.

What could be causing it/where could there still be macros I've missed?

Quintin

"Jim Thomlinson" wrote:

When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of
the worksheets or ThisWorkbook.
--
HTH...

Jim Thomlinson


"Bodyshopman" wrote:


-turn off macro warning window when all macros are deleted-
bodyshopman

macro warning window
 

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

Quintin wrote:

I've got the same problem.

I've delete every macro and line of VB code I can find in all 12 sheets in
the workbook. I save the workbook and close it. When I re-open the workbook,
I get prompted to enable macros again.

What could be causing it/where could there still be macros I've missed?

Quintin

"Jim Thomlinson" wrote:

When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of
the worksheets or ThisWorkbook.
--
HTH...

Jim Thomlinson


"Bodyshopman" wrote:


-turn off macro warning window when all macros are deleted-
bodyshopman

--

Dave Peterson

macro warning window
 

Thanks. That fixed it :-)

"Dave Peterson" wrote:

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

Quintin wrote:

I've got the same problem.

I've delete every macro and line of VB code I can find in all 12 sheets in
the workbook. I save the workbook and close it. When I re-open the workbook,
I get prompted to enable macros again.

What could be causing it/where could there still be macros I've missed?

Quintin

"Jim Thomlinson" wrote:

When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of
the worksheets or ThisWorkbook.
--
HTH...

Jim Thomlinson


"Bodyshopman" wrote:


-turn off macro warning window when all macros are deleted-
bodyshopman

--

Dave Peterson