Sorting Worksheets in a workbook

[Doehead]

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

 

[ozgrid.com]

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

 

[Doehead]

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

 

[Jacob Skaria]

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 ...........

 

[ozgrid.com]

Thanks Jacob, damn line breaks

 

[Chip Pearson]

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