+ Reply to Thread
Results 1 to 2 of 2

Excel 2010 to 2013: button activated macro won't run correctly

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2010, Excel 365
    Posts
    47

    Excel 2010 to 2013: button activated macro won't run correctly

    Attached is a Zip file that contains 2 workbooks, one called Barcode Generator and one called Test Data. The Test Data is a report that is run daily that tells us what equipment was brought into inventory the day before. We copy this data and paste it into the Barcode Generator. The Generator looks at a bunch of different qualifiers and filters the equipment between the List (equipment that need a barcode sticker) and the Secondary List (equipment that should already have a barcode sticker).

    This worked fine, but I recently got a new computer and now I'm having issues.
    Old computer: Windows 7, Excel 2010
    New computer: Windows 10, Excel 2013
    Issue: if I select Filter Data button to perform the macro (after I pasted the data from the Test Data workbook), it completely messes up the workbook (doesn't filter the data correctly, formatting on the List sheet is lost, and formatting on the Secondary Stickers sheet is lost). But, if I run the macro directly from Visual Basic, it works fine (Module 2, Filter_List macro).
    Any idea what's going on?

    Note: if you want to see the barcode on the Stickers sheets, you need to have the Code 128 font installed.

    Thank-you in advance for any help!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-06-2012
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2010, Excel 365
    Posts
    47

    Re: Excel 2010 to 2013: button activated macro won't run correctly

    I got it working! I had to change the code to unprotect the sheets individually...

    Original Code:
    Please Login or Register  to view this content.
    New Code:
    Please Login or Register  to view this content.

+ 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. Macro button works for 2010 users, but not 2013
    By jspatten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2015, 03:11 PM
  2. VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013
    By jayar2112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2015, 01:14 PM
  3. Macro from 2010 not working correctly in 2013
    By Phixer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:24 PM
  4. Excel 2013 wrong window activated from VBA
    By AdLoki in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-04-2014, 01:50 PM
  5. 2010 macro not working in 2013 via button
    By PaulieNZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 01:27 PM
  6. Excel 2010 Macro Not Referencing Numbers Correctly
    By datadigger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 07:58 PM
  7. Excel 2010 Macro Not Referencing Numbers Correctly
    By datadigger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2012, 12:41 PM

Tags for this Thread

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