------
________________
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
Hi Dave,
Thanks for your code. I was looking for columns only. Your code is working
perfectly. I have one more criteria needs to be included in this. Can you
include yesterday along with Today in the unlock columns?
Please let me know if you have any questions.
Regards,
Selva
On Thu, Jan
Hi,
Your request is a bit confusing. You say that your dates are B1:B32. So today's
date will be - lets say, in B10. It seems that you want to unlock Row 10, not a
column.
However, I've written code to unlock columns (as requested) but with dates in
A1:AA1.
If you want to unlock Rows, the co
