"Auto" macro to hide columns based on otuline Row level selection?

[jmthompson]

I've searched around and played with this some. What I'd like is to create a Worksheet macro for when the user picks a Outline Row level (on my subtotaled report), unused columns would be hidden.

Row level 5 = no hidden columns
Row level 4 = hide column D
Row level 3 = hide columns C & D
Row level 2 = hide columns B:D
Row level 1 = hide columns B:D

I can't figure out, first, how to use the current row level as a variable and secondly, what event I would use to launch the macro.

 

[GlennUK]

There is no event associated with changing outline levels. Would using the worksheet calculate event be acceptable?

 

[jmthompson]

Hey Glenn,
Thanks for responding. That is the route I eventually took, but the code I wrote caused a lot of screen flicker that wasn't suppressed by Application.ScreenUpdating=False. Would have been cool if it were seamless, but I finally considered the audience for this report and decided to eliminate that step.

I started another thread to resolve the screen flicker- http://www.mrexcel.com/forum/showthread.php?t=539661