Friday, October 31st, 2008
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.
(more…)
Popularity: 8% [?]
Posted in MS Office | No Comments »
Thursday, June 5th, 2008
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 marco below will unlock your sheet or workbook not matter what your original password is. However, it will NOT report the original password.
How to unprotect
1. First open your protected excel file
2. Launch the Visual Basic Editor
3. Copy and paste the following VB Code
(more…)
Popularity: 100% [?]
Posted in MS Office | 13 Comments »
