Re-Post: Before_Print Sub Doesn't Trigger
Tom
This works great. Thanks. A final, I think, refinement. In the message box, can we substitute the file name with Page numbers and number of copies
For example, the message box would say: Print Page 1? Yes No (We can omit reference to the zoom size)
according to the following schedule
On "scorecard", Page 1 (the only page) would be for range B1:BA4
On "financial", "learning", and "process", Page 1 would be for range B1:BA32; Page 2 would be for B33:BA64
and Page 3 would be for B65:BA96. Would there be a way to ask for all three print pages in one message box, with th
number of copies
Example: Print Page 1 ? Yes No Number of Copies: __
Print Page 2 ? Yes No Number of Copies: __
Print Page 3 ? Yes No Number of Copies: __
Thanks
Phil
|