MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shortcut for renaming worksheet


Posted by Anatoly on August 03, 2000 11:38 AM

Is there a short cut I can use for renaming a worksheet instead of double-clicking and then renaming it?


Posted by Anatoly on August 08, 0100 8:31 AM

Yes, I have checked. This is one thing that they don't have.

Posted by Anatoly on August 07, 0100 12:54 PM

Anatoly


You misunderstood me. I'm not looking for VBA answer, I'm trying to avoid using my mouse and double clicking on the tab in order to rename it, i.e. there is a short cut for opening a file - (Alt+F), etc. Is there one for renaming the worksheet?

Anatoly

Posted by Celia on August 08, 0100 4:23 PM

Anatoly
I can't imagine why you want to do this since double-clicking the sheet tab and typing in the new name would appear to be quite simple and efficient. However, you could put the following macro in a file, assign a shortcut key to the macro, and put the file in the XLStart folder.

Sub RenameSheet()
Dim newName As String
newName = InputBox("Enter the new sheet name")
ActiveSheet.Name = newName
End Sub

Celia


Posted by Celia on August 07, 0100 4:43 PM

Anatoly


Anatoly
I don't think so.
There is a complete list of all shortcut keys in the Help file under "Using Shortcut Keys". Presumably you have already checked this?
Celia

Posted by Celia on August 03, 0100 6:12 PM

Anatoly
If you want to do it with VBA, some sample syntax :-

Sheets("Present Name").Name="New Name"

Or

ActiveSheet.Name="New Name"

Celia