Results 1 to 3 of 3

Thread: Hiding Dialog Box in Excel from VB

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Hamilton, New Zealand
    Posts
    137
    Sorry for crossposting this to the general forum as well but I only just noticed this one and thought it may be more relevant

    I'm having trouble hiding the dialog box that excel displays when printing something.

    I can disable every other dialog by setting the displayalerts property to false, but this only affects dialogs that require input from the user.

    The dialog i am talking about is the one that says
    Now Printing Page # of #
    on the Printer Name
    And has a cancel button

    I am accessing Excel from my VB program and it is not visible but this little box flashes up all the time when I print.

    Does anyone have any ideas on how to hide it?

    Regards

    Matt Brown
    Hamilton, NZ
    VB6 C++ in Visual Studio 6sp4
    VB.net Beta 1

  2. #2
    New Member holmmd's Avatar
    Join Date
    Nov 2000
    Location
    Welington, NZ
    Posts
    15

    Smile

    Have you tried the FindWindow and SendMedssage API calls?
    Mark Holm
    Visual Studio 6 Enterprise(SP4)

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Hamilton, New Zealand
    Posts
    137
    I haven't yet holmmd but i'll give it a try

    Thanks

    Regards

    Matt Brown
    Hamilton, NZ
    VB6 C++ in Visual Studio 6sp4
    VB.net Beta 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width