Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i lock a cell? to save formula or function in it?
Hi Everyone,
Please help me to know about how i lock a cell? i make a sheet of my use and in that i mention lots of formulas and function and some other user use that sheet for there work now the problem is if the delete that formula or function from the sheet it become useless so i want to lock that particular cell so that no one can delete or edit it not even write in it except me. Please sort this quary |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i lock a cell? to save formula or function in it?
Hi, By default, all cells are locked when you choose Tools/Protection/Protect Sheet or Workbook. So you just have to go to the cells where you want the users to allow edition and choose Format/Cells/Protection and in the protection section untick the Locked check box. Then protect the worsheet with a password and it's done. -- oteixeira ------------------------------------------------------------------------ oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320 View this thread: http://www.excelforum.com/showthread...hreadid=558089 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL Function: cell reference by formula | Excel Worksheet Functions | |||
A function to indicate whether a cell contains formula or value? | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
IF Function to test formula in a cell | Excel Worksheet Functions | |||
revealing the contents of a formula | Excel Worksheet Functions |