workbook before print target
 

greetings, is it possible to use Wookbook_Before Print event with a target
worksheet, i.e., event occurs only when printing one worksheet out of a
workbook?

workbook before print target
 

You can insert a test of the ActiveSheet Name

If Activesheet.Name = "Sheet1" then
'Insert Code here
End if

Regards,

OssieMac

"mwam423" wrote:

greetings, is it possible to use Wookbook_Before Print event with a target
worksheet, i.e., event occurs only when printing one worksheet out of a
workbook?

workbook before print target
 

i see, appreciate the reply