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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies