View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Wilson[_2_] Phil Wilson[_2_] is offline
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