View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How to put worksheets in Alphabetical order?

Open the VBA editor by pressing ALT F11. In the editor, select your
workbook's project in the "tree view" on the left side of the screen (CTLR R
to view it if it is hidden). Then go to the Insert menu and choose Module.
In that code window, paste the code from www.cpearson.com/Excel/SortWB.aspx.

Once you have the code in the module, close the editor from the File menu to
return to Excel. There, press ALT F8 to display the available VBA
procedures, select the item and click RUN.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"LiveUser" wrote in message
...
I don't normally use VBA so if you could give me a little boost on a vague
step by step I would appreciate.

Where do I start and where do I enter.

Thank you.

"Gary''s Student" wrote:

See:

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


--
Gary''s Student - gsnu200765


"LiveUser" wrote:

Is it possible to put worksheets in Alphabetical order?

Thank you.