Frans_Truyens
asked on
Copy textboxes on excel sheet to another sheet at the same position
I have a workbook with multiple sheets. On the first sheet, there are many textboxes and commandbuttons. These controls should be copied to the other sheets on exactly the same position. Please help.
ASKER
I am going to try it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, this solves my problem.
Open in new window
Requires sheet1 to be named "Sheet1" (if not, change the code, in the obvious 2 spots)
The results on the other sheets looks the same, but is not 100% the same (it's more of a picture than a real control). So if you still need to edit the labels, command name, etc, this solution is not for you.
If no editing is needed, it could be useful.