gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
I know I can add code to rename a tab
Me.Name = "Summary"
But what I want to do is rename Sheet3. I am asking specifically just to rename sheet3 so if the user copies the tab, the code that renames doesn't happen on the new/copied tab.
I tried (obviously without success)
Sheet3.Name = "Summary"
Me.Name = "Summary"
But what I want to do is rename Sheet3. I am asking specifically just to rename sheet3 so if the user copies the tab, the code that renames doesn't happen on the new/copied tab.
I tried (obviously without success)
Sheet3.Name = "Summary"