View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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?