It can be done using DATA VALIDATION.......... ?>
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Wed, 11/5/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Re: How to lock the cells.
To: excel-macros@googlegroups.com
Date: Wednesday, November 5, 2008, 3:40 AM
right click on cell and go to Format -> Protection tab.. if locked box is
checked, cell will locked after protecting the sheet. If hidden box is checked,
cell formula will be hidden (i.e. will not show in formula bar) after
protecting the sheet. To lock a range, select your range and then go to Right
click -> Format -> Protection.
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: ram bhagath <[EMAIL PROTECTED]>
To: excel-macros@googlegroups.com
Sent: Tuesday, 4 November, 2008 6:18:31 PM
Subject: $$Excel-Macros$$ How to lock the cells.
Hello all,
Could you pls explain me how to lock cells in the below scenario:
- How to lock single cell
- How to lock range of cells
- how to hide the formula only for formula based cells.
Regards,
Ram.
Add more friends to your messenger and enjoy! Invite them now.
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
