Protect the sheet
 

Hi,
I would like to ask how can i protect the sheet so no one can delet
the content ( Formulas )

Also : can i protect cells

Thnx
SAM

--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496
View this thread: http://www.excelforum.com/showthread.php?threadid=26685

Protect the sheet
 

To protect the sheet, go to Tools menu, Protection, Protect Sheet.

Don't know about individual cells, but if the sheet is protected, n
one can alter your cells anyway.

Sambusa Wrote:
Hi,
I would like to ask how can i protect the sheet so no one can delet
the content ( Formulas )

Also : can i protect cells

Thnx
SAM

--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26685

Protect the sheet
 

you can protect the individual cells do this before you
protect the sheet go to the cells that you dont want to be
protected and then select them now right click choose
format cells you should see a tab called protection now
make sure that LOCKED is not ticked. if it is it means
that when you protect the sheet it will protect that cell.

by default all cells protections are locked so try it on a
new workbook you will see.

if you choose to protect sheet people can still delete the
worksheet. if you choose protect workbook they cant delete
the sheet but can delete the cells so maybe protect with
both options.


if you need help email me.

take it easy


-----Original Message-----

To protect the sheet, go to Tools menu, Protection,
Protect Sheet.

Don't know about individual cells, but if the sheet is
protected, no
one can alter your cells anyway.

Sambusa Wrote:
Hi,
I would like to ask how can i protect the sheet so no
one can delete
the content ( Formulas )

Also : can i protect cells

Thnx
SAMI


--
madbloke
----------------------------------------------------------
--------------
madbloke's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14422
View this thread:
http://www.excelforum.com/showthread...hreadid=266859

.