Locking Columns

  • Thread starter Thread starter Pablo
  • Start date Start date
P

Pablo

I have a worksheet that I want to allow people to work
in, but I want to restrict specific columns. Is there a
way to lock people out of columns within a worksheet?

Thanks,
 
Hi Pablo
select the cells/columns/rows you want to ALLOW entries. Goto 'Format -
Cells'; choose the tab 'Protection' and uncheck the protection. After
this goto 'Tools - Protection' and protect your worksheet

Note: This protection can easily be overcome
HTH
Frank
 
Back
Top