Locking excel cells

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

Hi all,

Is it possible to 'lock' a particular excel column(s) such
that cell entries cannot be modified - but the 'locked'
columns can be copied/pasted to other parts of the same
worksheets/workbook?

Don-
 
Don,

The answer to your question is No and Yes. If you "Lock"
a cell or a column or a row by setting the LOCKED property
in Cell Format and then Protect just the Sheet and NOT the
Workbook, you can Copy those protected cells and Paste
them in a NEW Sheet. The Pasted cells in the new sheet
will not be protected and editing will be available, but
the ones in the first sheet are protected.

Email me if I confused you.

-Rene
 
Back
Top