+ Reply to Thread
Results 1 to 6 of 6

Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Errors

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    5

    Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Errors

    First time poster, big issue.

    Created an XLSM file in Excel 2013 (32-bit) which will be customer's new invoice system. Everything works fine on my copy. When I send him my changes via email, everything again works fine for the customer who runs Office 2010 (32-bit Excel). However, if the customer makes any change to the file (even simply editing text), the file contains many errors upon reopening.

    Most notably, on start up the customer receives 2 errors from the Workbook_Open event. These errors include:
    -Run-time error '1004': Activate method of Worksheet class failed
    -Run-time error '1004': Method 'Sheets' of object '_Global' failed

    These errors only occur on the first load for the customer and will not reappear. However, my big issue seems to be that once these errors occur, formatting errors result that never get corrected. I have 200 rows within the worksheet that switch from hidden to visible depending on the size of the invoice. Within these hidden rows are Form Control buttons used to delete products existing on these rows. When these errors occur, the Form Control buttons will not follow rows that become visible. Instead all buttons located on hidden rows bunch together on the last visible row. Again, I cannot replicate any of these issues on my machine.

    The code for the Workbook_Open event:

    Please Login or Register  to view this content.
    It almost seems like the Workbook_Open event is executing before the sheet is open and thus none of the references exist. Is there a conversion process Excel is going through from 2013 to 2010 on start up that may be causing the delay in loading the form? Is it a Protection issue since the customer is receiving the form via the internet? I am out of logical ideas.

    Much confidential material exist in this workbook, so unfortunately I cannot post the entire workbook.


    I know I did not provide much but thanks for any help that can be provided,

    J.P.

  2. #2
    Registered User
    Join Date
    07-07-2014
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    5

    Re: Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Erro

    After some research, I found that Form Control buttons that exist in hidden rows can sometimes result in button heights of 0 when changed to visible. Seems to be a known bug in Excel 2010. I will report back and see if removing these Form Control buttons alters the other errors my customer is receiving.

    J.P.

  3. #3
    Forum Contributor
    Join Date
    10-30-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    173

    Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Format...

    Which lines throw the error? The user should be able to report that... Or make a rough video with their phone...

    Some general points of style:

    1. Because the code is in the ThisWorkbook module, you can replace all of the "ThisWorkbook" references with "Me"

    2. For walking the Sheets Collection, create a local variable like
    Please Login or Register  to view this content.
    And use
    Please Login or Register  to view this content.



    Sent from my iPad using Tapatalk

  4. #4
    Registered User
    Join Date
    07-07-2014
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    5

    Re: Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Erro

    Thanks for the reply coolblue.

    Executed suggested changes as well as removed all Form Control buttons. Will troubleshoot with customer, find erroneous lines, and report back. Thanks again.


    J.P

  5. #5
    Registered User
    Join Date
    07-07-2014
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    5

    Re: Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Erro

    Thanks for the reply coolblue.

    Executed suggested changes as well as removed all Form Control buttons. Will troubleshoot with customer, find erroneous lines, and report back. Thanks again.


    J.P

  6. #6
    Registered User
    Join Date
    07-07-2014
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    5

    Re: Created XLSM in Excel 2013, Customer Makes Change in Excel 2010 -> VBA,Formatting Erro

    Eliminating the Form Control buttons seemed to do the trick. There must be a conversion process from 2013 to 2010 that creates a delayed start up when loading the Form Control buttons. Weird, anyway problem solved. Thanks for the help.

    J.P.

+ 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. Excel 2013 won't run a macro attached to button created in excel 2003
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2020, 01:16 AM
  2. Excel 2013 crashes on opening specific *.xls or*.xlsm file
    By JochenS in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-23-2014, 02:58 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. Code created in Excel 2010 does not work with Excel 2013
    By Steve@Rugby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 10:14 AM
  5. Conditional Formatting Excel 2007 to 2010 errors
    By ThomDall in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-17-2012, 03:29 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