The cells that you want to be able to edit, under format cell, protection
tab, uncheck the "locked" box. (cells are protected by default)

Now go to Tools-Protection, protect sheet. You can play around w/ options if
you want, but you should be okay with default settings. Use a password if
desired.

You should now only be able to edit the cells that you setup.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hardip" wrote:

Hi All

I have a workbook and would like to make certain cells editable and lock
other cells. How do I achieve this functionality?

I'd appreciate any advise or guidance from the professionals in the forum.

Thanks in advance to all who respond.

Cheers, H