Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding the userFormDuring Print Preview Advice Please
I am using the following code which hides the user form during Print Preview.
How do I incorporate code to return (Unhide?) the UserForm if I click close on the preview window? Private Sub cmdPrintPreview_Click() Sheet1.PageSetup.PrintArea = "A1:U13" UserForm1.Hide Application.Dialogs(xlDialogPrintPreview).Show End Sub Thanks Demot |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding the userFormDuring Print Preview Advice Please
ahhh, just as I posted it came to me....!!
UserForm1.show.....as below..... If any one has any suggestions of better ways to achieve this.....with any reasons why it would be better done an alternate way..... they would be appreciated. Private Sub cmdPrintPreview_Click() Sheet1.PageSetup.PrintArea = "A1:U13" UserForm1.Hide Application.Dialogs(xlDialogPrintPreview).Show UserForm1.Show End Sub "Dermot" wrote: I am using the following code which hides the user form during Print Preview. How do I incorporate code to return (Unhide?) the UserForm if I click close on the preview window? Private Sub cmdPrintPreview_Click() Sheet1.PageSetup.PrintArea = "A1:U13" UserForm1.Hide Application.Dialogs(xlDialogPrintPreview).Show End Sub Thanks Demot |
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 |