--
________________
From: Prashant Pednekar
To: excel-macros@googlegroups.com; da...@grugeon.com.au
Sent: Mon, March 18, 2013 8:17:01 AM
Subject: Re: $$Excel-Macros$$ Unlock Cells on Condations
Dear Devid,
Tried with the same. Still fac
It works perfectly on my spreadsheet.
I think you filled the dates using a formula. Change xlFormulas to
xlValues.
It would also be good to put Dim r as Range at the head of the macro.
Regards
David Grugeon
On 15 March 2013 23:47, Prashant Pednekar wrote:
> Dear Dave, and other friends.
>
Dear Dave, and other friends.
I am using belwo code for locking rows. It is not working. Can you let me
know where i am going wrong. my date value is in first column.
Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
Rows("5:1200").Locked = True
With Range("A5:A1500")
Set
Find(Date, LookIn:=xlFormulas, lookat:=xlWhole)
> If Not c Is Nothing Then Columns(c.Column).Locked = False
> End With
> ActiveSheet.Protect
> End Sub
>
> Also, see attached.
> Presently the sheet is protected without a password.
> Regards - Dave.
>
n).Locked = False
End With
ActiveSheet.Protect
End Sub
Also, see attached.
Presently the sheet is protected without a password.
Regards - Dave.
> Date: Tue, 19 Jan 2010 15:42:22 -0800
> Subject: $$Excel-Macros$$ Unlock Cells on Condations
> From: s.sel
Hi,
I need some assistance in unlocking a range of cells based on date
conditions
For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.
It should not allow the user to enter data for yesterday or
tomorrow...
