Able to lock few cells in worksheet

  • Thread starter Thread starter bha_123
  • Start date Start date
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
 
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.)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Worksheet of Locked Workbook 2
How to lock cell and worksheet? 3
Locked worksheet & hyperlinks (w/ select locked cells unchecked) 1
Locked Several Worksheets, allow format cells/select unlocked cell 2
Lock specific cell 1
Locked cells are still able to be selected with proper protection 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Excel VBA 0

Back
Top