View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gil[_5_] Gil[_5_] is offline
external usenet poster
 
Posts: 9
Default ShowModal, Hide Form, Print Preview Office 2007

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