Home

Lock Range of columns based on date

Tyler Smith
Contributor

Hello,

 

I have been all over the internet and have tried 20-30 different ways but no luck. So i am looking to lock columns based on today's date and updating each day, I need this to lock any columns that are within +14 days of today. I have no experience in VBA at all, This is some of my first time really working in it. 

 

So if Today is 3/26/19 then any columns with header less than 14 days of today will lock so no one can edit them. I have attached my excel document, as you can see i have many columns with dates and a VBA code that will hide any columns that are passed todays date.

1 Reply

Anyone ever done anything like this? Also I have macros that are auto hiding columns based on dates. Will this effect anything.

Related Conversations