Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Macro does not work when file is sent to another computer

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro does not work when file is sent to another computer

    I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg.

    What could be wrong?

  2. #2
    Banned
    Join Date
    Feb 2003
    Location
    The Kingdom of Wessex
    Posts
    5,378
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro does not work when file is sent to another computer

    Don't you thin k it might help if you showed us the code and tell us where it errors, or shall we just guess?

  3. #3
    Board Regular
    Join Date
    Nov 2004
    Location
    England
    Posts
    263
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro does not work when file is sent to another computer

    It could be several things,

    1. is your macro stored in the actual worksheet or in your personal.xls workbook.

    2. is your bosses macro security level set to allow your macro to run.

    hth

    john
    Using Excel 2000 sp3 on XP sp2

  4. #4
    Board Regular
    Join Date
    Oct 2009
    Location
    PA
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro does not work when file is sent to another computer

    Quote Originally Posted by geddes_1310 View Post
    I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg.

    What could be wrong?

    Perhaps your boss has an older version of Excel ie some of my macros wriitn in Excel 2007 do not work in our offices Excel 2000 machines.

  5. #5
    Board Regular bertie's Avatar
    Join Date
    Jun 2009
    Location
    Coatbridge, Scotland
    Posts
    1,869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro does not work when file is sent to another computer

    It could also be your marco uses references which are not set on the other pc.

    Click Tools => References to check

Some videos you may like

User Tag List

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
  •