Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Message before print for specified worksheets
On OfficeKB i found code
Private Sub Workbook_BeforePrint(Cancel As Boolean) Msg = "Warning message" Title = "Warning TITLE" Response = MsgBox(Msg, vbYesNo + vbQuestion, Title) If Response = vbNo Then Cancel = True Exit Sub End If End Sub This code for all workbook. Need code for specified worksheets. In my situation for now i have two worksheets 'trips' and 'statistic' in the future may be more. Where page setup paper size: Legal (8 1/2 x 14 in). Messege will be: "Before print please insert to your printer paper size: Legal (8 1/2 x 14 in)." Thanks in advance. Sincerely, Igor (inta251) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200702/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Message Box | Excel Discussion (Misc queries) | |||
How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
How to print when an error message keeps showing? | Excel Discussion (Misc queries) | |||
Trouble printing message 'print to file' | Excel Discussion (Misc queries) | |||
Trouble printing message 'print to file' | Excel Discussion (Misc queries) |