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

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.

--
Jim
"Gil" wrote in message
...
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

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

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

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