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.
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: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=495606
- Apr 21 Sat 2007 20:36
Allow Edit Prevent Delete
close
全站熱搜
留言列表
發表留言