Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview
Hi,
I have a problem with .printpreview after a userform is displayed. The following code displays userform1 but does not show the printpreview of worksheet1. --Thanks! Sub test() With UserForm1 .Width = Application.Width .Height = Application.Height .Show vbModeless End With Worksheets(1).PrintPreview End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview
It's a bit pointless covering the whole area in a userform, as you cannot
interact with the app under it. Also, it seems that userform do not interact well in .PrintPreview. What are you trying to achieve ? NickHK "borg" wrote in message ... Hi, I have a problem with .printpreview after a userform is displayed. The following code displays userform1 but does not show the printpreview of worksheet1. --Thanks! Sub test() With UserForm1 .Width = Application.Width .Height = Application.Height .Show vbModeless End With Worksheets(1).PrintPreview End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview
Hi,
I think you should hide or unload the userform before .printpreview and load or show it again after .printpreview like Userform1.hide activesheet.printpreview Userform1.show thanks, halim borg menuliskan: Hi, I have a problem with .printpreview after a userform is displayed. The following code displays userform1 but does not show the printpreview of worksheet1. --Thanks! Sub test() With UserForm1 .Width = Application.Width .Height = Application.Height .Show vbModeless End With Worksheets(1).PrintPreview End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview
Thank you so much!!
" wrote: Hi, I think you should hide or unload the userform before .printpreview and load or show it again after .printpreview like Userform1.hide activesheet.printpreview Userform1.show thanks, halim borg menuliskan: Hi, I have a problem with .printpreview after a userform is displayed. The following code displays userform1 but does not show the printpreview of worksheet1. --Thanks! Sub test() With UserForm1 .Width = Application.Width .Height = Application.Height .Show vbModeless End With Worksheets(1).PrintPreview End Sub |
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 | |||
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) | |||
Why does macro speed slow after Excel Print or Print Preview? | Excel Programming |