Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Every time my macro copies a worksheet, the new sheet name appears in the Project window of VBEas something like Sheet11111111111(Sheet 1(9)). Whats the deal with this?

April 26, 2017appears copies macro project Sheet time window worksheet

0

Posted

Every time my macro copies a worksheet, the new sheet name appears in the Project window of VBEas something like Sheet11111111111(Sheet 1(9)). Whats the deal with this?

1 Answer

0

Posted

These strange names are the “code names” for Sheet objects, and they can get very unweildy if you do a lot of sheet copying. You can change the code name using the Properties window in the VBE.