VBA code to hide filtered columns (simple table 5 rows / 6 columns wide)

Hi,

I have a simple table in Excel 2010 (5 rows / 6 columns).
I would like the user to be able to filter the table.
After the filter, I would like to hide any columns that only contain (visible) 'N' characters.

I would like to do this in VBA.

The file can also be downloaded from:
https://dl.dropboxusercontent.com/u/...n_columns.xlsm

Any help much appreciated.
Thank you

MarvinP, thank you for the code / reply.

After 2 days of searching and trying different things, I've come to the conclusion that its not possible to do what I want.

Many controls (command buttons, comboboxes etc) allow you to click on them and gain access to the code window / events underneath so you can add your own code.
The Filter does not seem to have this property / ability.
I wanted to click on the filter and then the macro would run without having to do anything else.

Here I would have to :
(1) click on the filter and make my adjustments.
(2) then manually run the macro HideColIfAllN

I'm trying to avoid manully running step (2) - if you see what I mean.

Thanks anyway.

Hi e2010,

You may be able to trick Excel into doing what you want. It seems that a volatile function (such as SubTotal [of AutoFilter data]) on an unrelated sheet would generate the required event. Thanks to brettdj in the 2nd post in the following thread for the concept: http://stackoverflow.com/questions/1...nning-a-filter

See the file associated with post#4 in the following thread: http://www.excelforum.com/excel-prog...ml#post3883023

It may or may not point you in the right direction.

Lewis

thanks for the replys