Excel Lock
How do you lock the spreadsheet so nobody can fiddle with it?
Jamie
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 303 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Excel LockHow do you lock the spreadsheet so nobody can fiddle with it? Jamie |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Lock Excel
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
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.
lock sheet
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