RE: $$Excel-Macros$$ Message Box to Show ActiveSheet.PageSetup.Orientation

2012-06-27 Thread Rajan_Verma
alk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of stonesfan Sent: 27 June 2012 9:55 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Message Box to Show ActiveSheet.PageSetup.Orientation I need to trap PageSetup settings to determine if

$$Excel-Macros$$ Message Box to Show ActiveSheet.PageSetup.Orientation

2012-06-27 Thread stonesfan
I need to trap PageSetup settings to determine if the active worksheet can be printed programmatically. (Note that I'm not asking how to change them - if they are not within reason, the active sheet will not be printed.) I thought the following line of code would result in "xlPortrait" or "xlH