Lock Spread Sheets
Posted: Fri May 07, 2010 8:06 pm
Can Any body suggest me how to create locked Excel spread sheets with a path showing at the bottom. Thanks
To lock an Excel spreadsheet (Excel 2000) go to the Tools menu, then Protection, then Protect Sheet. I can't remember exactly where it is in Excel 2007, maybe in the review tab.
If there are cells you want to be able to type in even when the sheet is protected, before you protect it do the following: highlight the cell(s) you want to have open, go to the Format menu, click Cells. Then click the Protection tab. Uncheck the Locked checkbox, then select OK. Then go ahead and protect the sheet.
As far as a path, there are two ways. You can do a put it in a footer (some of the options include path/filename). Also, the following function in a cell will return the path & filename:
=cell("filename")
-Julie