View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jennie jennie is offline
external usenet poster
 
Posts: 1
Default MultiPage UserForm Printing Problem

Hi,

I have a user form (UserForm1) which has a multipage area in i
(MultiPage1) with 4 different pages.

At the moment I can print any single one of the pages using:

Sub PrintForm()

UserForm1.MultiPage1.Value = 3
UserForm1.PrintForm

End Sub

To print page 4 for example

I would ideally like to print all 4 pages together on one sheet o
paper (i.e. quarter sized)

Does anyone know how to do this?

Also, is it possible to change the background colour of the userfor
and multipage so that it doesn't print and waste ink.

Thanks for any help in advance
Jenni

--
Message posted from http://www.ExcelForum.com