Posted to microsoft.public.excel.misc

HKaplan

external usenet poster

Posts: 80

Lock Cells

Excel adopts the properties (i.e. locked status) of the adjacent
cells. Try creating a macro to insert the row and unlock the cell in
the macro statements.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
why do some cells not lock?	CDecuir	Excel Discussion (Misc queries)	1	April 16th 07 08:31 PM
lock cells.	Miri	Excel Discussion (Misc queries)	1	February 21st 07 09:42 AM
How To Lock Cells	Ziggy M	Excel Discussion (Misc queries)	3	August 18th 06 02:24 PM
Lock all cells?	JoeBed	Excel Discussion (Misc queries)	8	June 1st 06 07:21 PM
How do I lock all cells in a given row together to one another?	Michael Goldman	Excel Discussion (Misc queries)	1	May 27th 06 08:17 AM

All times are GMT +1. The time now is 07:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us