Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-16 Thread dguillett1
legroups.com Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlock Pl.reply On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh wrote: I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:3

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-16 Thread Abdulgani Shaikh
*From:* Abdulgani Shaikh > *Sent:* Saturday, April 14, 2012 5:18 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be > unlock > > Pl.reply > > > On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh > wrote: &

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-15 Thread dguillett1
If your request is for a reply, I did reply. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Abdulgani Shaikh Sent: Saturday, April 14, 2012 5:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-15 Thread Abdulgani Shaikh
Protect >> >> End Sub >> >> ** ** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh >> *Sent:* Apr/Sat/2012 12:23 >> *To:* excel-mac

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-15 Thread Abdulgani Shaikh
** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh > *Sent:* Apr/Sat/2012 02:03 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be > unlock > &g

RE: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-14 Thread Rajan_Verma
os@googlegroups.com] On Behalf Of ITP Abdulgani Shaikh Sent: Apr/Sat/2012 12:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlock Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh wrote: Dear F

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-14 Thread dguillett1
Provide your file with examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ITP Abdulgani Shaikh Sent: Saturday, April 14, 2012 1:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If date in One then another cell to be unlock Dear Freinds,

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-14 Thread Abdulgani Shaikh
>>> >>> Range("E3").Locked = False >>> >>> Else >>> >>> Range("E3").Locked = True >>> >>> End If >>> >>> End If**** >>> >>> Me.Pro

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-14 Thread Abdulgani Shaikh
ocked = True > > End If > > End If > > Me.Protect > > End Sub > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh > *Sent

RE: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-14 Thread Rajan_Verma
t;).Locked = True End If End If Me.Protect End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ITP Abdulgani Shaikh Sent: Apr/Sat/2012 12:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If date in One

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

2012-04-13 Thread ITP Abdulgani Shaikh
Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh < itpabdulg...@gmail.com> wrote: > Dear Freinds, > > Please help me on following issue > > My worksheet is protected, out of all cells, some cells are unprotected > for entering data. > If I am entering data in Ce