[mso] Re: Excel Command or VBA Code to list all Sheet names
- From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 8 Oct 2003 11:36:06 -0500
Thanks. I knew I had read this somewhere, just couldn't remember where.
I need a database of things I might find useful in the future and where
I read it cause I'm not sure that Ginko Biloba is working. <g>
Christine McDonald
Technical Specialist
Western Regional Office
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]=20
Sent: Wednesday, October 08, 2003 9:23 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Command or VBA Code to list all Sheet names
Hi Christine...Chad Welch wrote a great two-part article for my
newsletter on creating a Table of Contents in Excel using VBA, which
should give you exactly what you want:
Part 1:
http://personal-computer-tutor.com/abc1/v6/chad6.htm
Part 2:
http://personal-computer-tutor.com/abc2/v8/chad8.htm
Of course, since I'm not a VBA kinda gal, I do this a little
differently...what I do is click in cell A1 of each sheet and use the
Name Range feature to name that cell the same as the sheet name....then
once I have all the A1 cells named, I just go to a new sheet and
Insert>Name>Paste and click on the Paste List button and that pastes all
the names into that sheet.
Of course, Chad's way is better for some people cuz his way creates
clickable links to the pages...with my way, you have to use the Name
dropdown box to access the sheets.
Have fun :-)
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of McDonald, Christine, Ms, DCAA
Sent: Wednesday, October 08, 2003 12:05 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel Command or VBA Code to list all Sheet names
Is there an Excel command or VBA code that can be written to generate a
listing of all the sheet names in an Excel Workbook? Using Excel 2002
on Windows 2000. Thanks,
Christine McDonald
Technical Specialist
Western Regional Office
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
