Shortcut for renaming worksheet

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

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

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

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

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

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

Or

ActiveSheet.Name="New Name"

Celia