PDA

View Full Version : [SOLVED] Lock Column or Rows (Editing restriction)



ilyaskazi
06-03-2005, 01:12 AM
how to lock any specified column or row in excel or through vba??

I don't require any splitting / freezing panes.

If locked, user should not able to edit/delete any of the cells of locked column or row.

chef
06-03-2005, 03:03 AM
Will protection not work...

make sure locked check box in clicked in format cells protection

highlight other columns you want edited then uncheck locked box
then protect sheet..

users will only then be allowed to edit the colums etc you want them to...

regards
cgef

ilyaskazi
06-03-2005, 03:25 AM
its done. thanku chef.