I use macros in one workbook (A) to create another workbook (B) from Template (C). Template (C) has macros as part of it's makeup. Specifically, there's a macro that's triggered by the Worksheet Activate of a particular sheet ("SheetSpecial").
My problem is that after creation of B, B gets saved but remains open, A and C close without saving changes, but the Worksheet Activate macros in B don't work unless I close and reopen the workbook. How can I get them to be working from inception? I need this because my users will want to work on the workbook as soon as it's created.
Thanks in advance,
John
Bookmarks