On Sep 8, 9:57*am, "Jim Rech" wrote:
No because modal is the default.

--
Jim"Gil" wrote in message

...
On Sep 6, 11:56 am, "Jim Rech" wrote:





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.

--
Jim"Gil" wrote in message

....

Hi There,

I'm trying to getprintpreviewto 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 openprintpreviewand everything would
work.

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

Thanks,
Gil- Hide quoted text -

- Show quoted text -

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...