| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabs
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tabs
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tabs
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Min+Max from other Tabs | Excel Worksheet Functions | |||
| tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
| Can we modify any of the ribbon tabs or create new ribbon tabs? | New Users to Excel | |||
| hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
| Can i set up tabs within tabs on Excel? | Excel Worksheet Functions | |||
Linear Mode
