Home » Forums » Open Source Learning Center » Learning requests

Excel Lock

Submitted by Devilboy666 on 13 March, 2009 - 16:14

How do you lock the spreadsheet so nobody can fiddle with it?

Jamie

‹ VBA Program learn More Pivot table examples ›
»
Nick's picture

Lock Excel

Submitted by Nick on 13 March, 2009 - 19:54.

hi Jamie.

You need to add sheet protection.

steps:
Select all the cells, right click => format cells => protection => Select LOCKED

In Excel 2007, select the Review tab from the ribbon, and click on protect sheet.

in Excel 2003, go:
Tools => protection => protect sheet.

Enter a password that you won't forget... If u do forget it, you won't be able to modify it yourself !

Rgds

Nick

»

Error after locked

Submitted by abdulr58 on 10 June, 2009 - 17:57.

Yes i did it but a problem i am facing is that whole sheet will be locked but i want a cell without locking,

example if i made a vlookup program and i enter any value then it give me error of password and i am unable to enter value.

 

Please suggest.

»
Nick's picture

lock sheet

Submitted by Nick on 10 June, 2009 - 18:36.

Hi Abdul

I recommend you to do my Excel basics course...

http://excelexperts.com/Teach-Yourself-Excel-Lesson-2-Course-Outline

This bit should help you:

http://excelexperts.com/Teach-Yourself-Excel-Lesson-18-Protection

 

 

»