View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luca Brasi Luca Brasi is offline
external usenet poster
 
Posts: 28
Default Get page orientation of active sheet in Excel 2007

If a chart is selected in Excel 2007, using
ActiveSheet.PageSetup.Orientation doesn't seem to return the orientation
of the active sheet, but the orientation of the selected chart object
(whatever the meaning of this value is...?).

Is there another way to return the orientation of the active sheet (if
not programmatically unselect the chart shape first)?
Thanks