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:
I would really appreciate any insight you may have into why the different Excel versions behave differently.Please Login or Register to view this content.
Thanks for your time!
tom
Bookmarks