+ Reply to Thread
Results 1 to 2 of 2

Spreadsheet macros working in Excel 2010 but not in Excel 2013

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Spreadsheet macros working in Excel 2010 but not in Excel 2013

    So as title suggests I have a spreadhseet for my payroll which has several macros in it, this has worked fine for a number of years on various machines all running excel 2010 however we have just upgraded one pc and it has come with excel 2013 installed. The spreadsheet looks fine however when we try to run the 'Input' macro using the button assigned for this, it gets to part way through and just stops. If I run the macro from VBA it runs all the way through as expected.
    At first I thought it was a macro security issue but have set machine to 'Allow all macros' (which is the same as the other machines) and it still happens. Has anyone experienced anything like this? Any ideas on how to fix it?

    Thanks in advance,
    Nina

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,306

    Re: Spreadsheet macros working in Excel 2010 but not in Excel 2013

    I suggest you put some debug.print statements in the code to try to narrow down exactly where it stops. Then take it from there.


    Regards, TMS

+ 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. Macros written in Excel 2010 don't work in Excel 2013
    By Bukovnik in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-03-2015, 01:24 AM
  2. VBA Working in Excel 2010 and not 2013
    By Jason*** in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2014, 11:28 AM
  3. [SOLVED] Excel 2010 to Excel 2013 Eroor? PivotTable, ListBox VBA not working.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 07:49 AM
  4. [SOLVED] 2010 Excel stops working when running macros
    By Yamaha Rider in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 02:40 PM
  5. Macros working fine on Windows (Excel 2010), but not on Mac (Excel 2011)
    By six6to8eight in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-29-2012, 11:12 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