Hi,

I am using XL 2002 and I am working with a file with 45 worksheet
(tabs). The file is a forecasting model for 28 different projects
charts + different scenarios to group the projects. I want to set up
"print manager" with a macro that can allow me to print out th
scenarios. So far I know how to a) group sheets and show the prin
dialog box and b) locate a value in a range from the output of
dropdown list box in the VB.

However, I have different views in each of the worksheets. By this
mean that I have grouped columns to hide or unhide information. I wan
the macro to pick the value from the dropdown list box and from suc
value then select to hide or unhide the columns and change the prin
setup befor showing the print dialog box. I am sort of a beginner and
don't know how to start this new part of my macro.

Can anybody hel me

Cheers

--
redroy
-----------------------------------------------------------------------
redroyx's Profile: http://www.excelforum.com/member.php...fo&userid=1452
View this thread: http://www.excelforum.com/showthread.php?threadid=26148