Posted to microsoft.public.excel.programming

reggie

external usenet poster

Posts: 30

Determining which Print Button was clicked

Hi,

I'm using the Application WorkbookBeforePrint Event to hijack the normal
Print and Print Preview functions in Excel 2003 & display some customised
options. How do I determine whether the user clicked the Print button or the
Print Preview button?

thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Do until button clicked	kaiser	Excel Programming	3	August 31st 05 12:41 PM
Identifying Button Clicked	Tom Ogilvy	Excel Programming	0	July 23rd 04 06:38 PM
Identifying Button Clicked	Chip Pearson	Excel Programming	0	July 23rd 04 06:29 PM
Pause macro, add form button to sheet, continue macro when button clicked!	Flystar[_15_]	Excel Programming	1	May 26th 04 09:45 AM
How do I check if a user clicked the Print Cancel button	joanne	Excel Programming	0	September 5th 03 08:24 AM

All times are GMT +1. The time now is 12:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us