Before Print Event
-
-
-
Re: Before Print Event
I'm not sure if the BeforePrint event in Word is any different to the one in Excel, but if they behave the same, then simply pressing CTRL+P or going to File/Print will active the BeforePrint event. This event is run BEFORE the Print dialog box appears.
HTH
Ger -
Re: Before Print Event
i assumed as much, but it doesnt for some strange reason. do i need to bring a message box up or something?
-
Re: Before Print Event
Honestly not sure... not sure what your code is specifically trying to do, but you could jam in a msbox statement to see if it pops up before printing anything. That at least will tell you if the event is being triggered.
Ger
-
-
-
Re: Before Print Event
Reading up on this subject it seems that it isn't as simple as with Excel. You have to trap an event. This seems the best explanation
See if this helps
-
Re: Before Print Event
thanks roy, it works! the only problem now is that i need it to start when the application opens and it doesnt seem to want to.
i thought i had to use the
event, problem is i get a strange error message appear!
I read the document you linked to aswell, the
doesnt work unless you manually run it?
any ideas? thanks.
-
Re: Before Print Event
I found that as well, Word VBa is nothing like Excel's. There is a Document_Open event, maybe move the auto_exec code to there.
-
-
Re: Before Print Event
That's good, do you want to post the full code?
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!