| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview enablechanges = false
Good Morning Group,
The code below gives following; the userform hides and the preview page is opened and the SetUp and Margins buttons are disabled. When clicking the Close button on the preview page the above buttons are enabled. At a second click on the Close button the preview page is closed and the Userform is showed. How to avoid the second click and the unwanted enabling of the buttons. Grateful for some hints. Brgds CG Rosén UserForm1.Hide Application.Visible = True ActiveSheet.PrintPreview EnableChanges:=False ActiveSheet.PrintOut Preview:=True Application.Visible = False UserForm1.Show |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print preview enablechanges = false
ActiveSheet.PrintPreview EnableChanges:=False
ActiveSheet.PrintOut Preview:=True Can't you just delete that second line? "CG Rosén" wrote: Good Morning Group, The code below gives following; the userform hides and the preview page is opened and the SetUp and Margins buttons are disabled. When clicking the Close button on the preview page the above buttons are enabled. At a second click on the Close button the preview page is closed and the Userform is showed. How to avoid the second click and the unwanted enabling of the buttons. Grateful for some hints. Brgds CG Rosén UserForm1.Hide Application.Visible = True ActiveSheet.PrintPreview EnableChanges:=False ActiveSheet.PrintOut Preview:=True Application.Visible = False UserForm1.Show -- Dave Peterson |
| 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) | |||
Linear Mode
