PDA

Click to See Complete Forum and Search --> : Hiding Dialog Box in Excel from VB


mattbrown
Nov 23rd, 2000, 04:32 PM
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?

holmmd
Dec 5th, 2000, 06:11 AM
Have you tried the FindWindow and SendMedssage API calls?

mattbrown
Dec 5th, 2000, 02:28 PM
I haven't yet holmmd but i'll give it a try

Thanks