Suggestion

How about the creation of a new worksheet, and the title of its tab, all in
one smooth step, instead of in two steps? This would make worksheet creation
a lot simpler without the necessity of renaming the tab as you would want it
to be in the first instance.

Thanks!
------------
D.R.Steele

Which psychic function of Excel would you suggest name/title the tab when new
sheet is created?


Gord Dibben MS Excel MVP

On Mon, 3 Apr 2006 09:45:02 -0700, IGFET909 <[email protected]>
wrote:

>How about the creation of a new worksheet, and the title of its tab, all in
>one smooth step, instead of in two steps? This would make worksheet creation
>a lot simpler without the necessity of renaming the tab as you would want it
>to be in the first instance.
>
>Thanks!
>------------
>D.R.Steele

Just a guess, but I bet that the OP wanted a small form that would open the
Rename dialog and add it at the same time.

Kind of like this as a macro:

Option Explicit
Sub testme()

Dim myNewName As String
Dim wks As Worksheet

myNewName = InputBox(Prompt:="What's the new name")
If myNewName = "" Then
Exit Sub
End If

Set wks = Worksheets.Add
On Error Resume Next
wks.Name = myNewName
If Err.Number <> 0 Then
MsgBox "Invalid Name! Do it yourself."
Err.Clear
End If
On Error GoTo 0

End Sub


If the OP is new to macros, then the OP can read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben wrote:
>
> Which psychic function of Excel would you suggest name/title the tab when new
> sheet is created?
>
> Gord Dibben MS Excel MVP
>
> On Mon, 3 Apr 2006 09:45:02 -0700, IGFET909 <[email protected]>
> wrote:
>
> >How about the creation of a new worksheet, and the title of its tab, all in
> >one smooth step, instead of in two steps? This would make worksheet creation
> >a lot simpler without the necessity of renaming the tab as you would want it
> >to be in the first instance.
> >
> >Thanks!
> >------------
> >D.R.Steele

--

Dave Peterson

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.
--
D.R.Steele


"Dave Peterson" wrote:

> Just a guess, but I bet that the OP wanted a small form that would open the
> Rename dialog and add it at the same time.
>
> Kind of like this as a macro:
>
> Option Explicit
> Sub testme()
>
> Dim myNewName As String
> Dim wks As Worksheet
>
> myNewName = InputBox(Prompt:="What's the new name")
> If myNewName = "" Then
> Exit Sub
> End If
>
> Set wks = Worksheets.Add
> On Error Resume Next
> wks.Name = myNewName
> If Err.Number <> 0 Then
> MsgBox "Invalid Name! Do it yourself."
> Err.Clear
> End If
> On Error GoTo 0
>
> End Sub
>
>
> If the OP is new to macros, then the OP can read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> Gord Dibben wrote:
> >
> > Which psychic function of Excel would you suggest name/title the tab when new
> > sheet is created?
> >
> > Gord Dibben MS Excel MVP
> >
> > On Mon, 3 Apr 2006 09:45:02 -0700, IGFET909 <[email protected]>
> > wrote:
> >
> > >How about the creation of a new worksheet, and the title of its tab, all in
> > >one smooth step, instead of in two steps? This would make worksheet creation
> > >a lot simpler without the necessity of renaming the tab as you would want it
> > >to be in the first instance.
> > >
> > >Thanks!
> > >------------
> > >D.R.Steele
>
> --
>
> Dave Peterson
>

Seems logical. So, don't hold your breath!

Biff

"IGFET909" <[email protected]> wrote in message
news:[email protected]...
> 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.
> --
> D.R.Steele
>
>
> "Dave Peterson" wrote:
>
>> Just a guess, but I bet that the OP wanted a small form that would open
>> the
>> Rename dialog and add it at the same time.
>>
>> Kind of like this as a macro:
>>
>> Option Explicit
>> Sub testme()
>>
>> Dim myNewName As String
>> Dim wks As Worksheet
>>
>> myNewName = InputBox(Prompt:="What's the new name")
>> If myNewName = "" Then
>> Exit Sub
>> End If
>>
>> Set wks = Worksheets.Add
>> On Error Resume Next
>> wks.Name = myNewName
>> If Err.Number <> 0 Then
>> MsgBox "Invalid Name! Do it yourself."
>> Err.Clear
>> End If
>> On Error GoTo 0
>>
>> End Sub
>>
>>
>> If the OP is new to macros, then the OP can read David McRitchie's intro
>> at:
>> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>>
>> Gord Dibben wrote:
>> >
>> > Which psychic function of Excel would you suggest name/title the tab
>> > when new
>> > sheet is created?
>> >
>> > Gord Dibben MS Excel MVP
>> >
>> > On Mon, 3 Apr 2006 09:45:02 -0700, IGFET909
>> > <[email protected]>
>> > wrote:
>> >
>> > >How about the creation of a new worksheet, and the title of its tab,
>> > >all in
>> > >one smooth step, instead of in two steps? This would make worksheet
>> > >creation
>> > >a lot simpler without the necessity of renaming the tab as you would
>> > >want it
>> > >to be in the first instance.
>> > >
>> > >Thanks!
>> > >------------
>> > >D.R.Steele
>>
>> --
>>
>> Dave Peterson
>>

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 <[email protected]>
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.