Have a look at Dave P's macro which allows you to type the name into an inputbox
and create the sheet based on that.

Still requires manual intervention and more than one step to execute.

1. Click on a button or invoke the macro from a shortcut key combo.

2. Input the name.

3. Click OK or hit <ENTER key on the dialog box.


Gord

On Mon, 3 Apr 2006 18:38:02 -0700, IGFET909
wrote:

Thank you Gentlemen:

This request is sort of futuristic (which does not mean that MS is not
working on it). What I'm suggesting is merely what would be, for at least
this user, the next logical step when it comes to creation of a new worksheet.

As it currently stands there are two steps: (1) You create the worksheet.
(2) You rename the tab.

What I'm proposing is a one-step operation (and I'm not suggesting that it's
possible to do at this point with respect to Office Word 2003). The idea is,
in one step: (1) When you copy/create a new worksheet, you are, at that same
instance, able to name that worksheet whatever you want it to be.

In other words, combine two steps into one. That would save time and
effort. It seems like a reasonable expectation. It does not require any
"psychic" energy. It requires a more streamlined approach to
creating/copying a worksheet.

Thanks.