Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock Excel 2010 workbook from edits

Status
Not open for further replies.

EcoWill

Technical User
Jun 8, 2011
49
US
Hi - I want to lock workbooks and password protect them, but it ain't working. This is Excel 2010. I click Review > Protect Workbook> then check Structure and Windows, then put in a password, and after i do that, anyone who wants can still go in there and make any changes that they feel like. It will not lock. They can change my data, change the appearance, whatever. Any suggestions?
 



hi,


In the SaveAs > Tools button > General Options

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Actually, no. It is in Review > Protect Sheet dialog box. Found it, and it works. If you go File > Save As there is no Tools button in this version.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top