Here's our Microsoft Office Tip for.. October 20, 2003
Click Here to see a complete list of all of our previously released Tips!
More on Securing Workbooks
In a previous tip, we discussed securing your workbooks with a password. That way, only you--and anyone you share that password with--will have access to your data.
There's more to the password feature than just keeping unwanted people out of your data. You can also prevent someone from modifying your workbook. You may want to share the information but preserve it. If this is the case, you'd password-protect the workbook and the data.
To do so, choose File, Save As. From the Tools drop-down list, choose General Options. Next, in the Save Options dialog box, type the password you want to use. Specify both File Sharing options: Password To Open and Password To Option. Click OK. Then, type a filename for your document and click OK.