I have a fully working VBA macro workbook all programmed in english labellings
I have more than 40 activex control objects in it all having unique namings. I have more than 10 dynamic tables all having unique namings as well. Scope is whole workbook for all of them.
I would like to be able to offer two worksheets for english and french. The working is exactly the same for both except for the labellings.
How would I approach this problem?
To duplicate one worksheet to another will create a lot of objects that would have different names. It would be a huge logistics nightmare to keep my script working with so many internal name changes
Bookmarks