| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
when press the close button in printpreview
Private Sub CommandButton1_Click() Me.Hide ActiveSheet.PrintPreview End Sub and, press the close button in printpreview screen, and then show the userform. how coding.... *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
when press the close button in printpreview
You have to do it all in the same sub.
Something along the lines of... Private Sub CommandButton1_Click() Me.Hide ActiveSheet.PrintPreview Excel.ActiveWindow.View = xlNormalView DoEvents Me.Repaint Application.ScreenUpdating = True Me.Show End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "x taol" wrote in message Private Sub CommandButton1_Click() Me.Hide ActiveSheet.PrintPreview End Sub and, press the close button in printpreview screen, and then show the userform. how coding.... *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
when press the close button in printpreview
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| press button via vb and excel | Excel Programming | |||
| Code execution interrupted on PrintPreview close | Excel Programming | |||
| key Press on Forms Button | Excel Programming | |||
| Proteting against a button press | Excel Programming | |||
| [how to] VBA catching close/print in printpreview | Excel Programming | |||
Linear Mode
