Hello, Thank you very much
Regards, Chandra Shekar On Sun, Dec 26, 2010 at 2:23 AM, hanumant shinde <hanumant_5...@yahoo.co.in>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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