Allow Edit Prevent Delete
 

I have a multi user file. Some users enter data in one column others in the
same and/or other columns. I would like to allow users to edit any column
however prevent them from deleting any column.

Allow Edit Prevent Delete
 

When you protect the sheet you can select what options the user can have
in regards to cell/row/column formatting. They are provided in a list
below where you input the password. These settings however will not go
into effect unless you have protected the sheet.

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=495606