ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locking columns (https://www.excelbanter.com/excel-discussion-misc-queries/192446-locking-columns.html)

Sherry

Locking columns
 
I want to lock columns so others can't get into the document and delete or
hide a column, however I want them to be able to add a row so they can fill
out the appropriate data in each column. How do I do this?

Mike

Locking columns
 
Protect your workSHEET with a password. When you select to protect it, a box
will appear asking what you want users to be able to do or not to do. Delete
columns and insert columns can be enabled/disabled seperately here.

"Sherry" wrote:

I want to lock columns so others can't get into the document and delete or
hide a column, however I want them to be able to add a row so they can fill
out the appropriate data in each column. How do I do this?



All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com