Protection of some columns from insert

G

Gene

Hi there
here is my example:
* COLs A-C (user can do anything)
* COLs D-F (user can enter data BUT NOT insert a column)
* COLs G->end (user can do anything)

How do I protect COLs D-F with Tools>Protection.

THANKS!
Gene:)
 
D

Dave Peterson

Select all the columns, then Format|cells|protection tab|uncheck locked
Select D:F, then Format|cells|protection tab|check locked

When you protect the worksheet, those locked cells will be locked. The others
can be changed.

But there are lots of things that the user can't do on a protected worksheet.
The user won't be able to "do anything" to those cells.
 
Top