View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default Restrict cell deletion


There are a few options. Tools\Protection\Protect Sheet

To us this, you need to use Format\Cells\Protection to protect (or not)
individual cells. You then turn on/off protection with the
Tools\Protection\Protect Sheet command.

Tools\Protection\Protect Workbook.

This will stop anyone changing the structe of your workbook (including
adding rows etc). You may need to use both.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553547