Able to lock few cells in worksheet
 

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

Thanks,
sur

Able to lock few cells in worksheet
 

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

Able to lock few cells in worksheet
 

On Apr 16, 3:49 pm, Dave Peterson wrote:
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

Thanks a lot..it works.