Hiding columns based on Todays date.

[natkemon]

Hi,

I'm trying to use VBA to hide columns based on todays date.

For example: If todays date is the 22/6/2018, I would like it hide all columns before this date.

I think its a little different to what i have searched in google since my date format is not in dd/mm/yyyy... but rather either d , ddd or dddd

I have attached spreadsheet

[alansidman]

This should work for you

Please Login or Register  to view this content.

[natkemon]

It works very well.

Further to this. I Would like to know if these 2 things are possible

- Is it possible to run a button to UNHIDE all AND to rerun HIDE (as above).
- Rather than hiding it at exactly the date and before... is it possible to hide before from 7 days before todays date?

[Logit]

.
Or another paste in the Sheet Module :

Please Login or Register  to view this content.

Row 11 is used for dates from Jan 1 to Dec 31. The font and background colors were changed to match so as to blend in.

When the sheet is activated, any column less than today's date is hidden.

The workbook has UNHIDE also.

[alansidman]

Please Login or Register  to view this content.

Option Explicit

Please Login or Register  to view this content.

[natkemon]

Please Login or Register  to view this content.

Option Explicit

Please Login or Register  to view this content.

How would one Run these without having to go into VBA.

[alansidman]

Create a command button and link each to a button

https://support.office.com/en-us/art...d-9c72c843a283

[natkemon]

*EDIT. Fixed (: