Can I automatically sort worksheets in excel?
 

Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

You would need a macro for that

http://www.cpearson.com/excel/sortws.htm


--

Regards,

Peo Sjoblom

"Jimmy" wrote in message
...
Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

Do I enter the "VBA code" as a formula?

"Peo Sjoblom" wrote:

You would need a macro for that

http://www.cpearson.com/excel/sortws.htm


--

Regards,

Peo Sjoblom

"Jimmy" wrote in message
...
Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

If you check the index on Chip's website, there are instructions on where to
place the code and how to use it. Look under VBA and or macros


"Jimmy" wrote:

Do I enter the "VBA code" as a formula?

"Peo Sjoblom" wrote:

You would need a macro for that

http://www.cpearson.com/excel/sortws.htm


--

Regards,

Peo Sjoblom

"Jimmy" wrote in message
...
Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

Chip's website being

http://www.cpearson.com/

"Jimmy" wrote:

Do I enter the "VBA code" as a formula?

"Peo Sjoblom" wrote:

You would need a macro for that

http://www.cpearson.com/excel/sortws.htm


--

Regards,

Peo Sjoblom

"Jimmy" wrote in message
...
Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

Jimmy,

Press ALT+F11 to open the VBA Editor. There, go to the Insert
menu and choose Module. In that code module, paste the code from
my web site. Go back to Excel, press ALT+F8 to bring up the
Macros dialog, and choose SortWS from the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jimmy" wrote in message
...
Do I enter the "VBA code" as a formula?

"Peo Sjoblom" wrote:

You would need a macro for that

http://www.cpearson.com/excel/sortws.htm


--

Regards,

Peo Sjoblom

"Jimmy" wrote in message
...
Can I sort worksheets in excel by names on tabs?

Can I automatically sort worksheets in excel?
 

Jimmy,

Download my free Excel add-in "Excel Extras" to sort sheets,
insert a Table of Contents and others.
Comes with an install/use Word file...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"Jimmy"
wrote in message
...
Can I sort worksheets in excel by names on tabs?