Prevent Unauthorized Opening of Workbook

To enter a password: 1. From the File menu, select Save as. 2. From the Tools dropdown list, select General Options (in Excel 97 select Options). ...

Protecting Cells Containing Formulas in an Unprotected Sheet

In this article, to protect cells containing formula in an unprotected sheet, we will use Data validation option.   ...

Change the Task's progress bar colours by clicking it

So Simple, Just Click the progress bar fo each task and it will change it's colour If you want to add new bars the just copy any of the existing one...

Using F2 to edit ranges in Name Manager and Conditional Formatting

I hadn't considered entering the competition. But yesterday, I once again shared this tip with an OP and thought it might be useful to bring it to a w...

how to figure out that worksheet is set to Manual Calculation mode

my pet peeve - yup - that little exasperating option that users check on to infinitely p!$$ off others... you could be changing formulae furiously and...

Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

Excel 2002 and Excel 2003 enables selecting an exact data table on a Web site, and importing and refreshing only the needed data. To import and ref...

Getting Continuously Refreshed Data from a Web Site in Excel 2000

To import and refresh information from a Web site: 1. Open Excel 2000, and from the Data menu, select Get External Data, and then New Web Query. 2...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.