Sorting Worksheets in a workbook
 

Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

Sorting Worksheets in a workbook
 

See http://www.ozgrid.com/VBA/sort-sheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doehead" wrote in message
...
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but
I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

Sorting Worksheets in a workbook
 

Hi Dave, I did as was instructed by the website but I got a 'Compile Error'
any idea why?

"ozgrid.com" wrote:

See http://www.ozgrid.com/VBA/sort-sheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doehead" wrote in message
...
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but
I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

.

Sorting Worksheets in a workbook
 

Remove the blank line between the below two lines...and Dave's code should
work fine. A space followed by _ is a line separator

lReply = MsgBox("To sort .............

& "To sort Worksheets ...........

'remove the blank line (as below) so that VBE considers this as one line

lReply = MsgBox("To sort .............
& "To sort Worksheets ...........


--
Jacob (MVP - Excel)


"Doehead" wrote:

Hi Dave, I did as was instructed by the website but I got a 'Compile Error'
any idea why?

"ozgrid.com" wrote:

See http://www.ozgrid.com/VBA/sort-sheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doehead" wrote in message
...
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but
I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

.

Sorting Worksheets in a workbook
 

Thanks Jacob, damn line breaks :)


--
Regards
Dave Hawley
www.ozgrid.com
"Jacob Skaria" wrote in message
...
Remove the blank line between the below two lines...and Dave's code should
work fine. A space followed by _ is a line separator

lReply = MsgBox("To sort .............

& "To sort Worksheets ...........

'remove the blank line (as below) so that VBE considers this as one line

lReply = MsgBox("To sort .............
& "To sort Worksheets ...........


--
Jacob (MVP - Excel)


"Doehead" wrote:

Hi Dave, I did as was instructed by the website but I got a 'Compile
Error'
any idea why?

"ozgrid.com" wrote:

See http://www.ozgrid.com/VBA/sort-sheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doehead" wrote in message
...
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name'
but
I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

.

Sorting Worksheets in a workbook
 

Download the bas module zip file from
http://www.cpearson.com/Zips/modSortingWorksheets.zip, save it to some
folder (it doesn't matter where), and unzip the file. In VBA, go to
the File menu, choose Import and import the unzipped module.

Run the Sub named SortTheSheets to sort all the worksheets in the
workbook using the default values for the parameters to the main sort
procedure.

You need only one copy of the code, but the code must reside in a code
module, not one of the Sheet modules and not the ThisWorkbook code
module.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com






On Wed, 19 May 2010 17:54:01 -0700, Doehead
wrote:

Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks