Protecting Workbooks with a Digital Signature

MS-Excel 2013 allows you to add the digital signature to the workbook files. After checking the spreadsheet and verifying all the details, with the di...

Preventing Hidden Sheets from Appearing

When a sheet is hidden and the workbook is not protected, it will still appear in the list of hidden sheets in the Unhide box (from the Format menu, s...

Limiting the Movement in an Unprotected Sheet

In this example, the sheet is divided into two parts: an area where movement is allowed (the Scroll Area), and an area where movement is restricted (t...

Preventing Movement in Protected Areas in Microsoft Excel

You can divide the area of a sheet containing data into two parts: an area where movement is unrestricted (scroll area) and an area where movement is ...

Moving Between Unprotected Cells in a Protected Sheet

Using keyboard shortcuts To move between unprotected cells in a protected Sheet: Press Tab to move between unprotected cells in a protected shee...

Protecting Sheets / Cells in Microsoft Excel

You can protect the content of cells from being changed and/or hide the formulas of cells from being viewed. Conditions for protecting cells Th...

Protecting the Sheet or the Cells in the Sheet

Protecting the sheet means that the content of cells cannot be changed and/or formulas can be hidden from view. To protect a sheet: From the Too...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube