Excel: Sort Worksheets Ascending or Descending

Written by Hii Hiong Ching on October 31, 2008 – 8:21 pm -

This is VB code which will auto sort all sheets in the active workbook after execute it. It is easy for us to locate sheets when we have many sheets in our workbook.

Write the Code

Open the workbook for which we want to sort the sheets and press Alt + F11 to open the Visual Basic Editor, and select Insert > Module to insert a module. Copy and paste the following code in module just created.

Read the rest of this entry »

Popularity: 9%

No Comments comment | Posted in » MS Office

10+ New Beta Sites

October 19, 2008 – 9:00 am

Updated: 19 October 2008 We see new beta sites all the time, but are they any good? Here are some collection of new beta sites. Some of them provide free and ...

Free Web Invoices Generator: Black Sheep Invoices

September 11, 2008 – 10:03 pm

A nice script from Benjamin Keen - Black Sheep Invoices. With it, you can manage all your invoices directly on your web browser. You can try it through its live demo ...

dragtable: Visually reorder all your table columns

September 9, 2008 – 9:18 pm

Here is a amazing and beautiful script from Dan Vanderkam. We can just drag the column headings to rearrange the data in the table. Here is its URL for dragtable: http://www.danvk.org/wp/dragtable/

Google Chrome Web Browser

September 7, 2008 – 9:18 pm

Yes, a new web browser from Goolge - Google Chrome. As per what Goolge mention in its official website, it is a browser that combines a minimal design with sophisticated ...

How to Prevent Spam Bots From Collecting Email Addresses

June 23, 2008 – 4:11 pm

As I mentioned before in How to Include Subject, CC, BCC, and Email Body in Email Links, you are creating a risk to get spam if you simply placing email ...

How to Include Subject, CC, BCC, and Email Body in Email Links

June 22, 2008 – 3:48 pm

It is so easy to create a email link in our web page. Everyone who know or even don't know HTML, they can easily create an email link by software. Email ...

Excel: How to Unprotect Worksheet Without Password

June 5, 2008 – 9:13 am

You may sometimes forgot your password of your Microsoft Excel sheet or workbook, or the original author (usually ex-colleague) lock the workbook and didn't unlock it for next user, the ...

16 Cool Web Design in Black Style

May 25, 2008 – 12:39 am

Here is a list of 16 Cool Websites. You probably have heard of some of them, but if you’ve heard of all 16 of these cool websites, then consider yourself ...

How to Permanent Redirect a Web Page

May 4, 2008 – 2:44 pm

Sometimes we've just redesigned some pages of our web site. The pages have high search engine rankings that we don't want to lose. How can we safely redirect web site ...

Convert PhotoShop Creations into Strict XHTML compliant CSS Web Pages

April 21, 2008 – 11:48 pm

Upload .psd designs, download .html file and images. It's that simple to create CSS compliant webpages. Some web designers may not have fully knowledge to master CSS, and many of us ...

20+ HTTP 404 Not Found

April 9, 2008 – 11:24 pm

The 404 or Not Found error message is a HTTP standard response code indicating that the client was able to communicate with the server but either the server could not ...

OpenID Eliminates the Need for Multiple Usernames Across Different Websites

April 4, 2008 – 11:26 pm

The OpenID Foundation have announced that representatives from Google, IBM, Microsoft, VeriSign and Yahoo! have all joined its board, which means a massive step forward for the integration of singles ...

« Previous Entries

About Office-it.orG

This is a site to share my knowledge, discovery and experience related to my hobby and work. Most articles on this site are related to web design, web development, graphic design, short reviews, tips and tricks. I sometimes write some about Microsoft Office Application too.

Want to subscribe?

RSS Subscribe in a reader Or, subscribe via email:
Enter your email address:  
Find entries :