Naming a Sheet

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
2,347
Office Version
  1. 365
Platform
  1. 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"
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
.
Code:
Sub newname()
    Sheets("Sheet3").Name = "Summary"
End Sub
 
Upvote 0
The sheet name isn't currently "Sheet3". I want to name sheet3 (object)
 
Upvote 0
Try

Code:
Dim wsNameChange As Worksheet

Set wsNameChange = Sheet3

wsNameChange.Name = "Summary"
 
Upvote 0
.
Code:
Option Explicit


Sub namSht()
Sheet3.Name = "Summary"
End Sub

Above works whether placed in Routine Module or a Sheet Module.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top