12 Jun
When you save a workbook (or any other Microsoft Office document), some of your personal information like Author, Manager, Company and Last saved by are saved as File properties. If you want to share your workbook with others, then you may want to remove this information before you distribute it.
There are two things you can [...]
Posted in Security and Protection by: admin
No Comments
07 May
In a previous post we talked about how to protect worksheet elements. When you protect a worksheet, by default all its cells will be locked.
If you want to protect or unprotect some cells selectively then do the following:
Select the cells you want to protect / unprotect.
In the main menu click Format.
Click Cells. The Format Cells [...]
Posted in Security and Protection by: admin
No Comments
03 May
To prevent unauthorized users from performing certain worksheet tasks, like formatting cells, deleting rows or inserting rows, follow these steps:
Switch to the worksheet you want to protect.
On the Tools menu, point to Protection, and then click Protect Sheet.
Type a password for the sheet. Then reconfirm [...]
Posted in Security and Protection by: admin
No Comments
28 Apr
To allow only authorized users to view or modify your Excel workbook, you can secure your entire workbook file with a password. Follow the steps below to achieve this goal:
On the File menu, click Save As.
Click Tools.
On the Tools menu, click General Options.
If you want [...]
Posted in Security and Protection by: admin
No Comments