Protecting a Workbook by Making it Read-Only

PROTECTING THE CONTENTS OF A WORKBOOK BY MAKING IT A READ-ONLY WORKBOOK 

If you make a workbook read-only, users can view formulas in cells, and change values and formulas, but the changes cannot be saved. 

To make a workbook read-only, the document should be closed. In the Windows Start menu, choose Programs, and then Windows Explorer. In the Exploring window, open the drive or folder that contains the file and select the document name. Choose Properties from the File menu, choose the General tab, and check the Read-only check box. 

To make a Macintosh document read-only, select the name or icon of the document on the desktop. Choose Get Info from the File menu, and check the Locked check box. 

---