Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Printing Chart and UserForm on same page

Hi,

I have a workbook with several graphs driven by values on
multiple sheets.

I have set up a UserForm to focus users on the variables
they can change.

I would like to be able to print the settings on the
userform on the same page as a chart when the user
chooses to print it out.

I am thinking of setting a "static" image (ie GIF) of the
userform as the footer of the chart, however I am
struggling with how to do this straightforwardly as I
can't seem to use the nifty .export method for the
UserForm (plus I would prefer to not have to export the
image to an external file)

Any suggestions??

Phil Wilson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When printing page to pdf, my Excel XY chart shrinks to one half s dan kenkel Charts and Charting in Excel 2 December 20th 10 10:56 AM
Printing a chart to fill the whole page Becky P. Charts and Charting in Excel 1 May 16th 08 09:37 PM
Userform Printing sparx Excel Discussion (Misc queries) 8 July 31st 06 08:59 AM
Userform - Printing Greg B Excel Worksheet Functions 9 September 16th 05 12:11 AM
Userform - Printing Greg B Excel Discussion (Misc queries) 8 March 13th 05 02:40 PM


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"