Results 1 to 14 of 14

Enable Macros when workbook is created

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,152

    Enable Macros when workbook is created

    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
    Last edited by jomili; 11-17-2011 at 10:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1