Protection of some columns from insert
 

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 ToolsProtection.

THANKS!
Gene:)

Protection of some columns from insert
 

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.


Gene wrote:

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 ToolsProtection.

THANKS!
Gene:)

--

Dave Peterson