+ Reply to Thread
Results 1 to 7 of 7

Excel Version Problem - Office 365 (2016) vs. 2013

  1. #1
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Excel Version Problem - Office 365 (2016) vs. 2013

    I have a worksheet that is a template of sorts. The user clicks a button, a new tab is created and a copy of the main page (the "template") is pasted to the new tab. It works perfectly on my 2016 version but not on 2013. Let me explain the differences.

    THE BASIC IDEA: The main worksheet is a blank form. This form is used over and over again by clicking a button to create a copy in a new tab. A project may end up with dozens or even hundreds of tabs in the same workbook. Each iteration of the form has completely new data entered on the form. Some data is repeated on every subsequent form and this "static" data can be entered on the main "template" form so that when the button is clicked, the new form will contain the starting static information. It works perfectly...almost.

    THE PROBLEM: The workbook was created in Excel 2016 and users with Excel 20113 are experiencing two problems.

    TEXT BOX. There is a text box on the "template" form warning the user to add only static information that will be needed on every added tab. When the button is clicked, the new form is created but the text box is not supposed to appear on the new tab. For 2016 the new tab is created without the text box. For 2013, that text box appears on every new tab.

    VBA BUTTON. The button to create a new tab appears only on the main, "template" page. With 2016 when a new tab is created the button does not appear. In 2013 the button is copied too.

    I hesitate to post the entire workbook because of proprietary data but will attach an image showing the "culprits" and also the code that creates the new tab.

    2018-02-21_12-26-40.jpg

    Here is the code that creates the new tab:

    Please Login or Register  to view this content.
    I would really appreciate any insight you may have into why the different Excel versions behave differently.

    Thanks for your time!

    tom
    Attached Images Attached Images

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Too bad you can't post the workbook. I have 2013 at work and 2016 at home. I'l make a sheet with a textbox and copy it to see if it behaves as you describe.

    Looking at the code, you copy the entire sheet and not just the contents of its cells, so everything: data, comments, shapes, text boxes and code should wind up on the new sheet. The question isn't why is it showing up in 2013, but why it's not showing up in 2016?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Thanks for replying, Dflak. You ask a good question about what it is I am copying. I will try to narrow the copy area. but since the text box is in the copy area I am afraid change the copy area will only eliminate copy of the button.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Could you just delete the shapes by name? Add On Error Resume Next so Excel 2016 won't crash if the shape's not found:
    Please Login or Register  to view this content.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  5. #5
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Terrific idea, leelnich. I will give it a try and post back. Thanks!

  6. #6
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Worked like a charm, leelnich! Thanks for your suggestion. I really appreciated.

    Thanks to all for viewing. Marking this as solved.

  7. #7
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Excel Version Problem - Office 365 (2016) vs. 2013

    Cool! Thank you for the rep! - Lee

+ 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. Best version of office pro 2016 w/ disc?
    By X myth in forum Tips and Tutorials
    Replies: 2
    Last Post: 11-11-2017, 03:04 AM
  2. [SOLVED] Save 2016 version as 2013 version
    By BRISBANEBOB in forum Excel General
    Replies: 5
    Last Post: 04-13-2017, 02:19 AM
  3. Problem running Auto_Open from add-ins in Excel 2013 and 2016
    By Cashgenerator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2016, 08:53 AM
  4. Excel 2013 and Excel version 2015 Macros compatibility problem
    By Kreshan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2016, 02:35 AM
  5. Replies: 0
    Last Post: 01-09-2016, 02:02 PM
  6. [SOLVED] Implement office 2016 version
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2015, 01:32 PM
  7. [SOLVED] Date autofilter problem - Excel 2013 version
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2014, 12:10 AM

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