Posted to microsoft.public.excel.programming

external usenet poster

Posts: 99

how to lock/unlock certain cells

I have a worksheet with about 400 rows. Each row is for a specific product
and contains "specifications". The remainder of my workbook uses the lookup
function to populate from this worksheet. I need to "lock" this sheet so
that when one row is being edited no other row can accidentally be changed.
I have to clue where to start with this. Any suggestions???

thanks so much in advance!
--
AJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Lock Unlock cells in VBA	amit	Excel Programming	3	May 12th 08 05:07 PM
Lock/Unlock cells	BFife	Excel Worksheet Functions	2	October 25th 06 03:20 PM
lock/unlock cells	john tempest[_2_]	Excel Programming	7	March 16th 06 07:54 PM
Lock and Unlock Cells	Peter	Excel Programming	5	January 29th 05 04:32 PM
Lock and Unlock cells using VBA	Peter	Excel Discussion (Misc queries)	1	January 29th 05 02:00 PM

All times are GMT +1. The time now is 03:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us