I thought the idea was to disallow editing. Anyway, at the moment, you only need to select Protection from the tools menu and unprotect the sheet. The sheet will reprotect after any change.
As for multiple selections, why do you need it? Regards - Dave. Date: Thu, 22 Jul 2010 20:09:26 +0530 Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook From: sudhir.p...@gmail.com To: excel-macros@googlegroups.com CC: davebonall...@hotmail.com in addition of this macro,there is one more thing , if i want to edit one of my cell, and want to allow multiple secletion, then how it could be done, plz tell On Thu, Jul 22, 2010 at 8:00 PM, sudhir kumar <sudhir.p...@gmail.com> wrote: Dear Dave Bonallack sir thanks for sharing this important macro On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack <davebonall...@hotmail.com> wrote: You're welcome. Dave. > From: vidyutm...@gmail.com > Date: Thu, 22 Jul 2010 17:42:58 +0530 > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook > To: excel-macros@googlegroups.com > > Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks > again > > On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack > <davebonall...@hotmail.com> wrote: > > Hi, > > Have a look at the attached. > > The macro prevents the selection of multiple cells. > > If the selected cell contains data, it will be locked. > > If the selected cell is blank, it will be unlocked. > > Once a blank cell is edited, it will be locked automatically. > > The protection is not password protected. You can add that if you need. > > > > Regards - Dave. > > > > > >> From: vidyutm...@gmail.com > >> Date: Thu, 22 Jul 2010 12:09:43 +0530 > >> Subject: $$Excel-Macros$$ Need macro for attd workbook > >> To: excel-macros@googlegroups.com > >> > >> Hi respected members. > >> > >> i want ur help in macro. i v attd sample workbook, in that i want > >> macro that can protect rows which is not empty and unprotect empty > >> rows > >> > >> -- > >> > >> ---------------------------------------------------------------------------------- > >> 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 > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> HELP US GROW !! > >> > >> We reach over 7000 subscribers worldwide and receive many nice notes about > >> the learning and support from the group.Let friends and co-workers know > >> they > >> can subscribe to group at > >> http://groups.google.com/group/excel-macros/subscribe > > > > ________________________________ > > Find it on Domain.com.au Need a new place to live? > > > > -- > > ---------------------------------------------------------------------------------- > > 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 > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > -- > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe Find it at CarPoint.com.au New, Used, Demo, Dealer or Private? -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ Browse profiles for FREE! Meet local singles online. http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
