Re: $$Excel-Macros$$ Edit Cell
Thanks Lovely members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 wrote: > Unlock all you want to allow > lock that one > protect sheet > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Friday, June 08, 2012 9:07 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Edit Cell > > Dear > > Its is possible to Lock a particular cell only, I mean user cant > able to edit this cell only, rest they can able to edit. Even the E3 cell > should not be able to edit, Rest can be edit. Please see the attached. > thank you. > > > Thanks & Regards, > *Deba Ranjan P* > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Edit Cell
Unlock all you want to allow lock that one protect sheet Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Friday, June 08, 2012 9:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Edit Cell Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, Deba Ranjan P -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Edit Cell
Yes, Yes, its superb working thanks for the guides...Tnks Hilary & Noorain and Rest of this members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:52 PM, hilary lomotey wrote: > select all the cells, press ctrl +1 go to the protection tab, uncheck the > lock button, click ok, and then select the cell you want to lock and click > on ctrl +1 go to protection tab and check lock. click ok, go to review > ribbon and click on protect , ok, you shd be fine > > > On Fri, Jun 8, 2012 at 2:17 PM, NOORAIN ANSARI > wrote: > >> Hi Deba, >> >> Please check cell no. E3 in Sheet1, It is working fine with me. >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: >> >>> Sir, >>> >>>The file you have attached is the same that i have attached. Please >>> kindly check. Thanks for the same. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> > wrote: >>> Dear Deba, Please see attached sheet, If you have any query, Please reply On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: > Dear > > Its is possible to Lock a particular cell only, I mean user > cant able to edit this cell only, rest they can able to edit. Even the E3 > cell should not be able to edit, Rest can be edit. Please see the > attached. > thank you. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> -- >> FORUM RULES (986+ members alre
Re: $$Excel-Macros$$ Edit Cell
Dear Deba, Please check below link.. http://www.lytebyte.com/2009/06/15/how-to-protect-only-certain-cells-columns-or-rows-in-excel/ On Fri, Jun 8, 2012 at 7:50 PM, Deba Ranjan wrote: > Thanks , > > It is possible for A2:A7 range including with E3, > > i mean for E3, its fine, It s possible for A2 to A7 also the same lock. > > Please sir, Explain in details how you did !!! > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI > wrote: > >> Hi Deba, >> >> Please check cell no. E3 in Sheet1, It is working fine with me. >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: >> >>> Sir, >>> >>>The file you have attached is the same that i have attached. Please >>> kindly check. Thanks for the same. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> > wrote: >>> Dear Deba, Please see attached sheet, If you have any query, Please reply On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: > Dear > > Its is possible to Lock a particular cell only, I mean user > cant able to edit this cell only, rest they can able to edit. Even the E3 > cell should not be able to edit, Rest can be edit. Please see the > attached. > thank you. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, acc
Re: $$Excel-Macros$$ Edit Cell
select all the cells, press ctrl +1 go to the protection tab, uncheck the lock button, click ok, and then select the cell you want to lock and click on ctrl +1 go to protection tab and check lock. click ok, go to review ribbon and click on protect , ok, you shd be fine On Fri, Jun 8, 2012 at 2:17 PM, NOORAIN ANSARI wrote: > Hi Deba, > > Please check cell no. E3 in Sheet1, It is working fine with me. > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: > >> Sir, >> >>The file you have attached is the same that i have attached. Please >> kindly check. Thanks for the same. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Deba, >>> >>> Please see attached sheet, >>> >>> If you have any query, Please reply >>> >>> >>> On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: >>> Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknow
Re: $$Excel-Macros$$ Edit Cell
Thanks , It is possible for A2:A7 range including with E3, i mean for E3, its fine, It s possible for A2 to A7 also the same lock. Please sir, Explain in details how you did !!! Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI wrote: > Hi Deba, > > Please check cell no. E3 in Sheet1, It is working fine with me. > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: > >> Sir, >> >>The file you have attached is the same that i have attached. Please >> kindly check. Thanks for the same. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Deba, >>> >>> Please see attached sheet, >>> >>> If you have any query, Please reply >>> >>> >>> On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: >>> Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or
Re: $$Excel-Macros$$ Edit Cell
Hi Deba, Please check cell no. E3 in Sheet1, It is working fine with me. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: > Sir, > >The file you have attached is the same that i have attached. Please > kindly check. Thanks for the same. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI > wrote: > >> Dear Deba, >> >> Please see attached sheet, >> >> If you have any query, Please reply >> >> >> On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: >> >>> Dear >>> >>> Its is possible to Lock a particular cell only, I mean user >>> cant able to edit this cell only, rest they can able to edit. Even the E3 >>> cell should not be able to edit, Rest can be edit. Please see the attached. >>> thank you. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@go
Re: $$Excel-Macros$$ Edit Cell
Sir, The file you have attached is the same that i have attached. Please kindly check. Thanks for the same. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please see attached sheet, > > If you have any query, Please reply > > > On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: > >> Dear >> >> Its is possible to Lock a particular cell only, I mean user cant >> able to edit this cell only, rest they can able to edit. Even the E3 cell >> should not be able to edit, Rest can be edit. Please see the attached. >> thank you. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Edit Cell
Dear Deba, Please see attached sheet, If you have any query, Please reply On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: > Dear > > Its is possible to Lock a particular cell only, I mean user cant > able to edit this cell only, rest they can able to edit. Even the E3 cell > should not be able to edit, Rest can be edit. Please see the attached. > thank you. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Copy of EDIT CELL(Deba).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Edit Cell
Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com EDIT CELL.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet