Print Userform Landscape - VBA
Here's a post by Tom Ogilvy from Orlando Magalhães Filho:
http://google.com/groups?threadm=OA%...GP12.p hx.gbl Paste the picture of the userform on a temporary worksheet that's set up to print landscape. (Record a macro when you do the page setup). V-Man wrote: How do I print my userform in landscape mode instead of the portrait default mode? I don't want to print the Excel spreadsheet, just the userform. Thanks, V-Man -- Dave Peterson |
Print Userform Landscape - VBA
make sure you read my second posting in that thread. The first captured
the whole screen - second corrects to just capture the userform. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Here's a post by Tom Ogilvy from Orlando Magalhães Filho: http://google.com/groups?threadm=OA%...GP12.p hx.gbl Paste the picture of the userform on a temporary worksheet that's set up to print landscape. (Record a macro when you do the page setup). V-Man wrote: How do I print my userform in landscape mode instead of the portrait default mode? I don't want to print the Excel spreadsheet, just the userform. Thanks, V-Man -- Dave Peterson |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com