Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage UserForm Printing Problem
none of this is supported directly.
You could possibly go through each page, copy it as a picture and paste to the worksheet, then when you have all 4, print the worksheet. If you really want just the "information", you could extract the values and place them in cells with appropriate labelling, then print that range. -- Regards, Tom Ogilvy "jennie " wrote in message ... Hi, I have a user form (UserForm1) which has a multipage area in it (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 of paper (i.e. quarter sized) Does anyone know how to do this? Also, is it possible to change the background colour of the userform and multipage so that it doesn't print and waste ink. Thanks for any help in advance Jennie --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
activate a page of a Multipage in Userform | Excel Discussion (Misc queries) | |||
How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) | |||
How to show a userform using excel macro in multipage | Excel Programming | |||
MultiPage problem | Excel Programming | |||
MultiPage UserForm | Excel Programming |