Able to lock few cells in worksheet

Posted to microsoft.public.excel.misc

bha_123

external usenet poster

Posts: 2

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I lock only a few cells in Excel within a worksheet?	Locking cells in Excel	Excel Worksheet Functions	2	August 25th 06 02:46 AM
How To Lock Cells and Columns without Protecting Worksheet	lostinformulas	Excel Worksheet Functions	3	June 13th 06 10:55 PM
How to Lock the selected cells in Excel worksheet	Siva	New Users to Excel	1	May 8th 06 11:52 AM
Can I lock a set of cells in a worksheet?	puneetarora_12	Excel Discussion (Misc queries)	3	July 8th 05 11:07 PM
How can I lock a number of cells within a worksheet?	IGA	Excel Discussion (Misc queries)	4	February 25th 05 01:38 AM

All times are GMT +1. The time now is 08:41 PM.

Menu

About Us