Print Preview Office 2007?

[Gil]

Hi There,

I'm trying to get print preview to work from a form in office 2007.
The form needs to have showmodal=true. In previous versions of offce
I
could hide the form, then open print preview and everything would
work.


In 2007 I hide the form, open print preview and all the buttons are
grayed out. If I set the showmodal property on the form which calls
the print preview = false everything works. I don't want to set the
showmodal to false. I just want to hide the form and open the print
preview. Any suggestions? I was thinking of programatically switching
the modal property but apparently that can only be set at runtime.


Thanks,
Gil

 

[Jim Rech]

I just threw together a quick example like this:

Private Sub CommandButton1_Click()
Me.Hide
Sheet1.PrintPreview
Me.Show
End Sub

and it worked the same in Excel 2007 as 2003. All buttons in Print Preview
were enabled. Your situation must have another wrinkle or two.

 

[Gil]

I just threw together a quick example like this:

Private Sub CommandButton1_Click()
    Me.Hide
    Sheet1.PrintPreview
    Me.Show
End Sub

and it worked the same in Excel 2007 as 2003.  All buttons inPrintPreview
were enabled.  Your situation must have another wrinkle or two.

--








- Show quoted text -

Jim,

Did you have showmodal=true on the form?

Thanks,
Gil

 

[Jim Rech]

No because modal is the default.

--
Jim

I just threw together a quick example like this:

Private Sub CommandButton1_Click()
Me.Hide
Sheet1.PrintPreview
Me.Show
End Sub

and it worked the same in Excel 2007 as 2003. All buttons inPrintPreview
were enabled. Your situation must have another wrinkle or two.

--








- Show quoted text -

Jim,

Did you have showmodal=true on the form?

Thanks,
Gil

 

[Gil]

No because modal is the default.

--







Jim,

Did you have showmodal=true on the form?

Thanks,
Gil- Hide quoted text -

- Show quoted text -

My problem is that modal and has to be set to true and then I can not
do a print preview after hiding the form...