Automatically Hide Columns

**xlsnovice** · 08-04-2013, 03:13 PM

I am trying to automatically hide columns based on dates. I have a set of dates ranging from the beginning of August this year until the end of December 2019. I am trying to hide all columns that are at least a day ahead of the current date. Today on 8/4/13 it would show all columns up until today along with tomorrow 8/5/13.

8/1/2013	8/2/2013	8/3/2013	8/4/2013	8/5/2013

**MikeNDavis** · 08-04-2013, 03:32 PM

I think that this would require VBA. You can conditionally make cells appear blank by using conditional formatting, but to actually hide the column you would need to have VBA code that executed when the spreadsheet was opened or when activated via a button or running a macro. Is that what you had in mind?

**xladept** · 08-05-2013, 12:08 AM

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name