MrExcel Publishing
Your One Stop for Excel Tips & Solutions

workbook_beforeprint question


Posted by blake on February 14, 2002 9:27 AM

does anyone know of a way to figure out how the beforeprint macro was initiated, ie if print or printpreview was selected? any help is appreciated, thanks.


Posted by Juan Pablo G. on February 14, 2002 9:46 AM

After reading your 500 posts on the same question I found this on Google

http://groups.google.com/groups?q=BeforePrint+Preview+group:microsoft.public.excel.programming+group:microsoft.public.excel.programming&hl=es&selm=OY4fzIwAAHA.218%40cppssbbsa02.microsoft.com&rnum=2

Maybe that can help.

Juan Pablo G.

Posted by Juan Pablo G. on February 14, 2002 9:50 AM

Also found this one, it's a little better I feel, but it would require you to REPLACE the Print Icon And the Print Menu, in order to set PrintDisabled to False.

Juan Pablo G.

Posted by Juan Pablo G. on February 14, 2002 9:51 AM

URL address is:

http://groups.google.com/groups?q=BeforePrint+Preview+group:microsoft.public.excel.programming+group:microsoft.public.excel.programming&hl=es&selm=GdX4N1hazGIiF1yBNWadvF2QNYz2%404ax.com&rnum=5

Posted by blake on February 14, 2002 11:19 AM

Re: URL address is:

sorry for all the post, thanks for the help, i appreciate it.

Posted by JohnG on February 15, 2002 12:40 PM

This just shows that they were having the same problem with Print and Print Preview with the Before_Print event.

Posted by JohnG on February 15, 2002 12:41 PM

This just shows that they were having the same problem with Print and Print Preview with the Before_Print event.