| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trapping Print events in VBA
Hi,
I'm trapping the App_workbookbefore Print Event which is working wonderfully! See http://www.cpearson.com/excel/AppEvent.aspx But The Question I've got is it possible to return what sheet, if only one sheet is printed or sheets if multiple sheets are printed. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trapping Print events in VBA
Take a look at the
ActiveWindow.SelectedSheets property, to capture which sheets the user is printing (unless the print command comes from the VBA .PrintOut method). In article . com, JJ wrote: Hi, I'm trapping the App_workbookbefore Print Event which is working wonderfully! See http://www.cpearson.com/excel/AppEvent.aspx But The Question I've got is it possible to return what sheet, if only one sheet is printed or sheets if multiple sheets are printed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Events - Trapping arrow key strokes | Charts and Charting in Excel | |||
| Trapping Excel events in c# | Excel Programming | |||
| Capturing Print and Print Preview events | Excel Programming | |||
| Trapping Events generated by a Worksheet | Excel Programming | |||
| trapping click events on shapes | Excel Programming | |||
![JJ[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
