I have a spreadsheet “A” which can create a simplified version of itself
called, say, “B”. In the process of creating B, A creates a new
workbook, names it B, copies certain tabs from A into B, deletes any
VBA code associated with those tabs and then closes B saving updates.
As a result, B has no macros or any VBA. However, if B is then opened,
the disable/enable macros window appears. This does not make any sense
because there are no macros in B. Everytime B is opened the
enable/disable macros window appears. However, if B is then resaved
(no other changes), and reopened, the enable/disable macros window is
gone. If I add additional statements in A to open B and close B saving
updates, the problem does not disappear.

What is happening here?

Is there something that I could do in A such that B does not have to be
resaved before the enable/disable macros window goes away?

Thanks


---
Message posted from http://www.ExcelForum.com/