ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/226706-re-tabs.html)

Easy, see:

http://www.cpearson.com/excel/sortws.aspx
--
Gary''s Student - gsnu200843

"Dale" wrote:

Hi

Is it possible to sort tabs alphabetically ??? Can it be done on both 2007
and 2003 versions ???

Thanks

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary''s Student - gsnu200843

"Dale" wrote:

Hiya

Sorry but I'm not that advanced When I've unraveled the code, where does it
go?

"Gary''s Student" wrote in message
...
Easy, see:

http://www.cpearson.com/excel/sortws.aspx
--
Gary''s Student - gsnu200843

"Dale" wrote:

Hi

Is it possible to sort tabs alphabetically ??? Can it be done on both
2007
and 2003 versions ???

Thanks

Thanks again, that worked fine

"Gary''s Student" wrote in message
...

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary''s Student - gsnu200843

"Dale" wrote:

Hiya

Sorry but I'm not that advanced When I've unraveled the code, where does
it
go?

"Gary''s Student" wrote in
message
...
Easy, see:

http://www.cpearson.com/excel/sortws.aspx
--
Gary''s Student - gsnu200843

"Dale" wrote:

Hi

Is it possible to sort tabs alphabetically ??? Can it be done on both
2007
and 2003 versions ???

Thanks