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


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?


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

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


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


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?

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

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

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


ActiveSheet.Name="New Name"