ExcelBanter - Protect selected column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protect selected column (https://www.excelbanter.com/excel-discussion-misc-queries/221681-protect-selected-column.html)

Fareez

Protect selected column

Dear Friend
Is there any possibilities to protecet by password only selected column or
cel or row without protecting whole work sheet.
thanks

Ron@Buy

Protect selected column

Yes
Highlight column or cells that you do NOT want to protect then Format Cells
Protection and untick 'Locked' OK. Now protect the worksheet and you will
be only be able to make entries in the column/cells that you unlocked.
Hope this helps.

"Fareez" wrote:

Dear Friend
Is there any possibilities to protecet by password only selected column or
cel or row without protecting whole work sheet.
thanks

All times are GMT +1. The time now is 02:20 AM.