View Single Post
  #2   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

On Jul 16, 11:19 am, Gil wrote:
Hi There,

I'm trying to get printpreviewto work from a form in office2007.
The form needs to have showmodal=true. In previous versions of offce I
could hide the form, then open printpreviewand everything would
work.

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

Thanks,
Gil


Anyone have any hints on this?
THanks,
Gil