Detecting which toolbar button was pressed

JohnG · Feb 20th, 2002, 07:41 AM

I am passing this on because I was asked this and do not know an answer.

The reason is that both the Print button and the Print Preview button activate the Before_Print event that has been set up and what needs to take place is that it should only be run if the Print button was selected.
NOTE: Print Preview actualy calls the event twice, 1st when it is pressed and 2nd if the print option within the print previeew is selected.

Juan Pablo González · Feb 20th, 2002, 08:13 AM

I thought this question had been already addressed in the old board.

JohnG · Feb 20th, 2002, 08:26 AM

The link provided sets up its own print routine using a shadow sheet in the BeforePrint it does not differentiate betwen which button was pressed.

Quote:

On 2002-02-20 07:13, Juan Pablo G. wrote:
I thought this question had been already addressed in the old board.

Feb 20th, 2002, 08:13 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I thought this question had been already addressed in the old board. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 07:41 AM	#1
JohnG Board Regular Join Date: Feb 2002 Location: SRC Posts: 165	I am passing this on because I was asked this and do not know an answer. The reason is that both the Print button and the Print Preview button activate the Before_Print event that has been set up and what needs to take place is that it should only be run if the Print button was selected. NOTE: Print Preview actualy calls the event twice, 1st when it is pressed and 2nd if the print option within the print previeew is selected.