Results 1 to 3 of 3

Thread: using excel macro when source doc not open
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2013
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arrow using excel macro when source doc not open

    I have successfully made 13 macros in a Workbook. At present, unless if have the Workbook on screen, or minimised, I can`t use them in other very similar workbooks. (I use these for recording teaching records.) Is there any way I can edit the macros so they are available in all workbooks without getting involved in Visual Basic ?

  2. #2
    Board Regular vds1's Avatar
    Join Date
    Oct 2011
    Posts
    1,175
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: using excel macro when source doc not open

    ---------------------------------------------------------------------------
    VDS1

    Using Office 2010

    Blog :
    http://wizardvba.blogspot.com

    Currently looking for opportunities in Canada.



  3. #3
    New Member
    Join Date
    Apr 2013
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default re: security questions preventing using Personal Macro Workbook

    Thankyou very much for these useful links. I managed to link some of my workbooks to the Personal Macro File but not all. I keep getting dire warnings about security. I have tried their TRUSTED SOURCES Menu and just clicked on those involving User Start Up but the macros only work in some work books. Do I HAVE to have the source workbook open before the link works ? The awkward files do have the Open in All Workbooks link open.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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