simply select E12:J22 cells lock them then protect sheet using password so nobody can unprotect it. see the attached file n let me know if it works for u.
________________________________ From: Chandra Shekar <chandrashekarb....@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, 23 December, 2010 3:48:40 PM Subject: Re: $$Excel-Macros$$ Re: Lock the Object Hello, Thank you for ur reply. If we right click mouse on the object we can edit the object. Please check it out. On Wed, Dec 22, 2010 at 8:06 PM, JsinSk <jsin...@gmail.com> wrote: I believe you just need to set the locked object on your item (already >done in your sheet), and then put protection on the sheet. (Tools| >Protection|Protect Sheet) > >On Dec 22, 7:08 am, Chandra Shekar <chandrashekarb....@gmail.com> >wrote: >> Hello, >> >> How to lock the object? User should not edit the object or delete the >> object. >> >> Please find attached file. >> >> Thanks >> >> Chandra Shekar >> >> Object_Lock.xls >> 25KViewDownload > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Object_Lock.xls
Description: MS-Excel spreadsheet