Hello,
I am having a problem with the page orientation remaining in the landscape position. Every time I reenter the application I need to reset it because it keeps going back to portroit. I noticed the help screen states you cannot set the page setups for macros or modules. I have some VBA code written for a switchboard in which I access this report, I would think the options would be dimmed out if I couldn't change anything, and its not. It initally lets me change the orientation and will print the selected orientation but then it reverts back once you come out of the application.
So my question is, is there a code I can add so the page orientation stays in landscape? Or do you have a different recommendation for this problem.
Look forward to your response
DebbieV
I am having a problem with the page orientation remaining in the landscape position. Every time I reenter the application I need to reset it because it keeps going back to portroit. I noticed the help screen states you cannot set the page setups for macros or modules. I have some VBA code written for a switchboard in which I access this report, I would think the options would be dimmed out if I couldn't change anything, and its not. It initally lets me change the orientation and will print the selected orientation but then it reverts back once you come out of the application.
So my question is, is there a code I can add so the page orientation stays in landscape? Or do you have a different recommendation for this problem.
Look forward to your response
DebbieV