View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Ostermann Peter Ostermann is offline
external usenet poster
 
Posts: 25
Default Conflict between xlDialogSendMail and xlDialogPrintPreview

Hi folks,

using
Application.Dialogs(xlDialogPrintPreview).Show by itself
it works fine.

The problem happens after I called
Application.Dialogs(xlDialogSendMail).Show


Calling again the preview, of the to be printed page of the
spreadsheet, it also shows up, but is frozen and not
clickable at all. Only option left is that Excel has to be shut
down.

If needed I can post some surrounding code or give
more details. For any hint I will be more than thankful.

Greetings
Peter