Monday, February 14, 2011

How to Protect and Share a Workbook in Microsoft Excel 2003


1. Open the workbook by running your application and then scrolling to the “File” tab and selecting “Open.”
2. Access the security properties menu. Scroll to the “Tools” tab on the command bar and then select “Protection.” A submenu will open.
3. Select “Protect and Share Workbook.”
4. Set protect and share properties. Make sure you check the box labeled “Sharing With Track Changes.” This will allow you to see all changes made by users who work on the book. Finally, enter the desired password in the “Password” field and then click 'OK' to protect and share the workbook.

Blogger news