Hi Guys,
Harry - Yes, Excel always names a sheet by adding a "(2)" after the sheet
name whenever we make a first time copy, (second time - it will add (3), and
then (4) and so on...) no matter how many times we open or re-open it. But
when we try to make a copy of "Sample (2)", Excel will name it as "Sample
(2) (2)",. As per the code, Sample (2) will be re-named instantly with the
name provided in the textbox, so each time a copy of 'Sample' is made, Excel
will treat it as first time copy hence it will name it as "Sample (2)"
because the earlier one doesn't exist. Hope this clarifies your query.
Simran - You're welcome.
Best regards,
AJ
On Sun, Mar 21, 2010 at 12:35 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Aj,
>
> Looks like a great solution for simran's problem. I have a question
> regarding a part of the code
>
> Sheets("Sample").Visible = True
> Sheets("Sample").Select
> Sheets("Sample").Copy After:=Worksheets(Worksheets.Count)
> Sheets("Sample (2)").Select
> Sheets("Sample (2)").Name = TextBox1
>
> What i can see is, when we make a copy of the Sample sheet, it is
> automatically renamed as "Sample (2)". Is it always the case that when
> we make a copy of a worksheet it will automatically be renamed as
> "Name (2)"?
> Example: Worksheet name: "ABC", its copy will be "ABC (2)"
> automatically?
>
> And will this hold good when we reopen the workbook again??????? I
> know it does, but how does excel automatically rename it as (2).....i
> hope i have been able to present my thoughts
>
> Please advise
>
> Harry
>
> On Mar 20, 3:14 pm, Abhishek Jain <abhishek....@gmail.com> wrote:
> > Hi,
> >
> > Please check the attached file and advise if this is what you want. Feel
> > free to revert for any clarification or further help you may need.
> >
> > Cheers!
> >
> > AJ
> >
> >
> >
> > On Fri, Mar 19, 2010 at 11:52 PM, Simran Singh <simran....@gmail.com>
> wrote:
> > > Hello experts,
> >
> > > I am preparing a tracker attached with this mail. What i have done so
> far
> > > is that in the first sheet "Summary" user when double click on the cell
> > > containing name of the person, that particular sheet will open. On that
> > > sheet command button "Back to Summary" is there to reach back on the
> > > "Summary" sheet. There is more than 200 people for which i have to
> prepare
> > > individual sheet. So what I want is, when a user has to add a name and
> new
> > > sheet of new party, there is a command button on the "Summary" sheet on
> the
> > > top. User just click on that button and one Text Toll will ask for the
> name
> > > of that sheet and create a sheet of that name. In that new sheet one
> command
> > > button "Back to Summary" should be there and script for that command
> button
> > > also there to reach back to the "Summary" sheet.
> >
> > > thanks in advance
> >
> > > Regards,
> > > Simran Singh
> >
> > > --
> >
> > >
> ----------------------------------------------------------------------------------
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our Facebook Group @
> > >http://www.facebook.com/group.php?gid=287779555678
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe
> >
> > > To unsubscribe from this group, send email to excel-macros+
> > > unsubscribegooglegroups.com or reply to this email with the words
> "REMOVE
> > > ME" as the subject.
> >
> >
> >
> > Simran.xls
> > 62KViewDownload- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
To unsubscribe from this group, send email to
excel-macros+unsubscribegooglegroups.com or reply to this email with the words
"REMOVE ME" as the subject.
