Rename grouped control elements

ThomasHOL

New Member
Joined
Oct 15, 2014
Messages
30
I’m building a excel sheet where i’m using a template sheet that I copy to a new sheet whenever I need it. This works fine but I have one problem as I have created a group of control elements in order for me to maintain their relative location to each other. But when I copy the control it changes name from Group 1 to Group 2 etc and since I use the name in a macro its giving me quite a few problems.

Can anyone help me renaming the group so it don’t change when I copy the sheet.

http://www.screencast.com/t/PEqqKbmL example of the group
 
Last edited:

ask2tsp

Active Member
Joined
Feb 18, 2015
Messages
484
when you copy the template sheet like this
Code:
    With ThisWorkbook
        .Worksheets("template").Copy after:=.Worksheets(.Worksheets.Count)
    End With
all the names are unchanged.
 

Forum statistics

Threads
1,086,120
Messages
5,387,960
Members
402,090
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top