how do i format inserted cells in protected worksheet?

=?Utf-8?B?SnVzdGlu?=

Guest

Posts: n/a

21st Feb 2006

Once I lock or unlock cells and protect the worksheet I can not edit any
cells inserted after I have locked the sheet. I can insert a row once the
sheet is protected but the new row of cells are defaulted as locked and I can
not format them without unlocking the sheet. Is there a way to format those
cells while the sheet is protected?

« Excel should allow exchange between cells | Text Error Message »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit text format in non-protected cells in protected worksheet	Bonnie	Microsoft Excel Misc	1	19th Apr 2008 04:48 PM
Allow rows to be inserted and edited in a protected worksheet	=?Utf-8?B?Tm92aWNlaW5leGNlbA==?=	Microsoft Excel Worksheet Functions	2	19th Dec 2006 04:41 AM
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel?	divya	Microsoft Excel Programming	2	20th Jul 2006 02:04 PM
Copying a worksheet witrh protected cells to a new worksheet	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Worksheet Functions	1	1st Feb 2006 02:19 PM
Re: Copying a worksheet witrh protected cells to a new worksheet	Tiscali NewsGroup	Microsoft Excel Worksheet Functions	0	31st Jan 2006 11:11 PM