PC Review


Reply
Thread Tools Rate Thread

how can i Cell Locked

 
 
masood
Guest
Posts: n/a
 
      31st May 2006

hi to all
can i cell locked. i mean when i write formula in cell, after i locke
this cell no body delete or over write in this cell. i think
understand my point. my english is very poor Plz help me

thanks
masoo

--
masoo
-----------------------------------------------------------------------
masood's Profile: http://www.excelforum.com/member.php...fo&userid=3496
View this thread: http://www.excelforum.com/showthread.php?threadid=54700

 
Reply With Quote
 
 
 
 
Ardus Petus
Guest
Posts: n/a
 
      31st May 2006
Select all cells that CAN be changed
Format>Cell>Protection, uncheck Locked
Tools>Protection>Protect sheet

Default value for cell protection is Locked

HTH
--
AP

"masood" <(E-Mail Removed)> a écrit dans
le message de news: (E-Mail Removed)...
>
> hi to all
> can i cell locked. i mean when i write formula in cell, after i locked
> this cell no body delete or over write in this cell. i think u
> understand my point. my english is very poor Plz help me
>
> thanks
> masood
>
>
> --
> masood
> ------------------------------------------------------------------------
> masood's Profile:
> http://www.excelforum.com/member.php...o&userid=34964
> View this thread: http://www.excelforum.com/showthread...hreadid=547004
>



 
Reply With Quote
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
locked cell not locked Wanna Learn Microsoft Excel Misc 1 17th Dec 2008 06:01 PM
Get Locked Cell Value Jimbob Microsoft Excel Programming 1 4th Apr 2008 12:04 AM
VBA for Cell locked please help peddie Microsoft Excel Programming 2 21st Aug 2006 04:09 PM
Cell scrolling if locked on =?Utf-8?B?R2xhc3Nob3VzZQ==?= Microsoft Excel New Users 1 24th Nov 2004 01:05 AM
Making a cell reference in a formula locked when copying to new cell? Lionel B. Dyck Microsoft Excel Discussion 3 19th Oct 2004 01:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:28 PM.