Sorting worksheets

**Onesock** · 10-08-2012, 01:19 AM

Hi Everyone

Could someone please tell me how to sort worksheets in a workbook alphabetically.

Thanks

**Sadath31** · 10-08-2012, 01:49 AM

this code will sort worksheet A-Z

HTML Code:

**JBeaucaire** · 10-08-2012, 01:52 AM

This should do it:

Please Login or Register  to view this content.

**Onesock** · 10-09-2012, 05:14 PM

Thanks for the responses.
I must say that I dont understand what you have replied. Please , if you dont mind explain to me what/how do I use the code.
Regards
Onesock

**JBeaucaire** · 10-09-2012, 05:25 PM

My apologies, this isn't the Programming Forum, so your VBA-only question slipped past me that you might not know how to use macros.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

**Onesock** · 10-09-2012, 05:48 PM

Thanks again

This works great.
Am I supposed to sign the macros. Im not very familiar with macros at all , but when I open my spreadsheet , a window pops up talks about security levels etc. Not really sure what this means , but it comes up everytime I open the spreadsheet.
Please advise.

**JBeaucaire** · 10-10-2012, 01:22 AM

That is normal. The last thing you want to do is turn that warning off. You WANT to know anytime you're opening a workbook that has macros in it and you WANT the opportunity to specifically indicate to Excel to NOT allow the macros to work if you're not sure. It's a mild price to pay to keep your system a little safer from workbooks with unexpected code in them.

If that takes care of your original question, please select Thread Tools from the menu above and mark the thread as solved. Thanks.