Able to lock few cells in worksheet

B

bha_123

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

Thanks,
sur
 
D

Dave Peterson

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.)
 
B

bha_123

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.)
Click to expand...

Thanks a lot..it works.
 
Top