So do some testing.
Start the macro by pressing F8 and hover over some of the values to see what values it is returning. eg.
ActiveWindow.ActivePane.View.Zoom.PageColumns
ActiveWindow.ActivePane.View.Zoom.PageFit
Once you understand what values are being returned, you can choose the correct If test
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|