In the particular instance, Cancel is just a flag that you can set to cancel
printing. In the event procedure, you can test for a particular condition,
and cancel the print.
As to the rest, you need to practice, read some books, check the NGs, and
ask specific questions.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"sowetoddid " wrote in message
...
I have clicked on all of the links that I can find posted in this forum,
trying to learn how to compile VB codes. A lot of the codes make
sense, except for the extra info the gets stuck between lines. Does
anyone know a good webpage that analyzes codes line by line, explaining
what each part does?
What is the significance of...
(Cancel As Boolean)
and
(By Val SaveAsUI As Boolean, Cancel As Boolean)
I see these in codes coming after Private Sub Workbook_BeforePrint
Thanks.
---
Message posted from http://www.ExcelForum.com/