is there a way to arrange worksheets in alphabetical order?
S Sandy Mann Sep 19, 2007 #2 See your other thread in worksheet.functions. Please do not multi-post -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
See your other thread in worksheet.functions. Please do not multi-post -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
D Dave Peterson Sep 19, 2007 #3 You can click and drag them by the tabs and move them to their rightful locations--or you could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
You can click and drag them by the tabs and move them to their rightful locations--or you could run a macro: Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
F François Sep 23, 2007 #4 Hi, here's 3 examples (but in french language !) which should help you : http://boisgontierjacques.free.fr/fichiers/Formulaire/ChoixFeuilleBOControles.xls In a non modal TextBox , and so available on all the sheets : http://boisgontierjacques.free.fr/fichiers/Form_ListeOnglets.xls http://boisgontierjacques.free.fr/fichiers/Formulaire/Form_ChoixFeuille.xls Files done by Jacques BOISGONTIER François
Hi, here's 3 examples (but in french language !) which should help you : http://boisgontierjacques.free.fr/fichiers/Formulaire/ChoixFeuilleBOControles.xls In a non modal TextBox , and so available on all the sheets : http://boisgontierjacques.free.fr/fichiers/Form_ListeOnglets.xls http://boisgontierjacques.free.fr/fichiers/Formulaire/Form_ChoixFeuille.xls Files done by Jacques BOISGONTIER François