+ Reply to Thread
Results 1 to 2 of 2

Excel Upgrade to 2013, Macro runs erratically with macro assigned to button (shape)

  1. #1
    Registered User
    Join Date
    10-27-2010
    Location
    Salisbury, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    41

    Excel Upgrade to 2013, Macro runs erratically with macro assigned to button (shape)

    My company upgraded everyone's Microsoft package to 2013 over the weekend. I believe we were running 2010 before that. Anyhow, I have a workbook with multiple sheets created that get populated with current data that is imported from another source. Each worksheet is for a different product line. This tool served us well until we tried to use it this morning for the first time with 2013. The update happens when you open the worksheet and there is a rectangle shape at the top of each sheet that says "Update". When you select it, an assigned macro will run. The macro will run, but the results are now for all of the imported data, in lieu of just the filtered data for the one particular product line on that worksheet. I noticed that if I open the editor and run the macro from there, it will run correctly. Any help would be much appreciated. Thanks, Steve

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Excel Upgrade to 2013, Macro runs erratically with macro assigned to button (shape)

    Hello Steve,

    Upgrades will often add new functions and remove old ones. To isolate the problem, you should post the macro code. Without it, we are simply guessing at the cause.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Upgrade to Excel 2013 - Macro error 'the object invoked has discon....'
    By craigp46 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2015, 06:26 PM
  2. Shape Position Locks When Assigned a Macro
    By primed in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2014, 11:27 AM
  3. Conditional formatting on shape assigned macro
    By arvindm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2013, 11:10 AM
  4. Macro issue may have when upgrade excel from 2003 to 2013
    By lhollis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2013, 03:21 AM
  5. Replies: 0
    Last Post: 11-30-2012, 01:29 PM
  6. Custom Toolbar Button No Longer Runs Assigned Macro
    By Bryan in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 01:10 PM
  7. shape (with macro assigned) flashes upon click
    By grime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 01:40 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