ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   lock up rows w/dates diff than current year (https://www.excelbanter.com/excel-programming/313457-lock-up-rows-w-dates-diff-than-current-year.html)

Myriam

lock up rows w/dates diff than current year
 
Please, HelP!!!
I have a sheet where the User inputs daily information and it spans over
several
years. I want to restrict the use of cells in all years but the current year.
I need something like this matching current year's dates
Four years span:
2004-2007 A1:A1461
For 2004:

Dim ws As Worksheet
Set ws = Sheet (1)
ws.Unprotect
ws.Rows(367:1461).EntireRow.Locked = True
ws.Protect

Thanks!



All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com