Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Print Preview
I'm using multiple page userforms. On one of the pages I have a comman
button to Print Preview one of the worksheets. My goal is to allow th person to preview the answers after they have entered all th information on the userforms. The problem is when I Print Preview a page the print preview page stay behind the userform and Excel doesn't allow me to get control of th print preview window. I've tried open the user form with th vbModeless option but it still does not work. Is it possible to be in a userform and print preview a worksheet? I so, how would I do it? Thanks for any help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Print Preview
Steven,
You need to hide the form prior to calling the print preview, then show the form after. For example, TheForm.Hide ActiveSheet.PrintOut Preview:=True TheForm.Show -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Steven Ducotey " wrote in message ... I'm using multiple page userforms. On one of the pages I have a command button to Print Preview one of the worksheets. My goal is to allow the person to preview the answers after they have entered all the information on the userforms. The problem is when I Print Preview a page the print preview page stays behind the userform and Excel doesn't allow me to get control of the print preview window. I've tried open the user form with the vbModeless option but it still does not work. Is it possible to be in a userform and print preview a worksheet? If so, how would I do it? Thanks for any help! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Print Preview
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |