Automatically hide columns based on date when opening Excel workbook

Hello
I have been asked to hide complete columns when opening an Excel document (single sheet) based on dates being older than the current day. I have managed to work out I need some VBA coding but that's where my knowledge stops. My Excel worksheet has the date in full (although only part of it shows due to cell formatting), i.e. 30/10/2019 through cells D3:AZV3 and when opening the document I would like all the columns hiding for all previous dates - hopefully I have attached the sample Excel document.
Hoping someone can assist.
Many thanks

Add this in the workbook module:

Please Login or Register  to view this content.

Which column do you want to hide, for argument the first column & check value of B1

Make some variation of the above code

Please Login or Register  to view this content.

Originally Posted by mrspock

Is this also possible to do it by week
See first sheet invoer
Yes i'm Dutch but for the VBA code i don't think it will make a difference
I have 5 machines i want to put the faults in for a week and after that week i want to hide the past week
Thx for any help in front

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread