Hi,
I'm currently trying to build a workbook whereby the user will click one of four buttons on a 'Menu' worksheet, which will then create a copy of one of four hidden worksheets, make said copy visible and rename it accordingly.
I obtained and modified the following code for this purpose, and it works fine where the four template worksheets I'm using are visible. However, when I hide them (as is my intention for the final version), the code does make the correct copy but then immediately hides it, and renames the menu worksheet (the only visible tab when the workbook is first opened) with the name intended for the copy.
My question is, how do I ensure that the copy, when made, remains the active worksheet in order that the code below will make it visible and rename it appropriately? I'm stumped. Any help greatly appreciated!
PS - there is a version of this subroutine for each of the four buttons I refer to.
Bookmarks