Record a macro when you unprotect your cells that should be able to be change.
Continue recording when you protect the cells that should not be changed.
Continue recording when you protect the worksheet.

Cell protection is under:
Format|cells|Protection tab

Worksheet protection is under:
tools|Protection|protect sheet

(These are xl2003 menus.)

bha_123 wrote:

Hi, I want only few cells in my worksheet to be locked using VBA
program. How do i do that?

Thanks,
sur

--

Dave Peterson