Remove Mystery Enable Macro Event on WB open

[bdb1974]

Hi all,

I've got a child workbook which is created from a source/parent workbook, worksheet.
(a worksheet saved as a new workbook).

This child workbook after creation, has worksheet objects embedded on the sheet and
module codes. I've have code that is run which removes all the sheet objects and
macros from the workbook. When I open the newly created workbook, I get a
the "Security" message window appearing which gives the user the option to
disable or enable all macros. Looking in the VBA project for the workbook shows no
module macros or sheet macro. I'm bewildered as to why I'm getting the enable macro
window popping up on workbook open.

I've attached a copy of the child workbook for review. If anyone can please tell my why this is happening and how to resolve this issue, i sure would appreciate it.

Thanks,


BDB

[snb]

The size of this file is disproportional.

I removed all columns/rows that didn't contain data.
I changed the workbook property keepchangehistory to False.
I changed the workbook property updateremotereferences to False.
I saved the workbook (23K)
I opened it: no warnings any more.

[bdb1974]

How do I auto fix this using code?

[snb]

Please Login or Register  to view this content.