+ Reply to Thread
Results 1 to 5 of 5

Getting sheets with macros to work on other computers.

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2007 (work) 2013 (home)
    Posts
    37

    Getting sheets with macros to work on other computers.

    When I create a sheet with macros at home, the macros are not recognized (seen, allowed) when I send the sheet to my computer at work.

    What settings do I have to change on my work computer to make it recognize the macros?

    Thanks much

  2. #2
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Getting sheets with macros to work on other computers.

    This could be happened if you used any path address from the computer on the code or the excel version on both PC are not same. So it would be better if you can show us the codes.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Getting sheets with macros to work on other computers.

    One possibility is "Macro Security Setting", see
    https://support.office.com/en-us/art...f-e8621e8fe373

  4. #4
    Registered User
    Join Date
    03-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2007 (work) 2013 (home)
    Posts
    37

    Re: Getting sheets with macros to work on other computers.

    That's okay. Actually I am using 2 different versions (2010 at home and 2007 at work). I think the problem is that my work computer utilizes security settings I can do nothing about.

  5. #5
    Registered User
    Join Date
    03-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2007 (work) 2013 (home)
    Posts
    37

    Re: Getting sheets with macros to work on other computers.

    Thanks for the link. I'll try some things I see here when I send the file to work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Why [A1] does not work on some computers
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-19-2014, 02:15 PM
  2. Macro won't work on different computers
    By bditomasso in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2013, 04:54 PM
  3. UDF does not work on other computers even when appropriate add-in is installed
    By ATufts in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2011, 06:14 PM
  4. How can i get the filters in my sheets to work when i add macros 2 move between pages
    By luckydiamond in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2011, 05:34 AM
  5. Macros on other computers....
    By Sparkybear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2008, 09:47 AM
  6. Replies: 2
    Last Post: 09-01-2005, 09:05 AM
  7. [SOLVED] How do I transfer macros in excel between two computers?
    By diningdesk in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 12:05 PM
  8. Formula won't work on some computers
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2005, 03:06 PM

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