Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have used the following code but this assumes the specific WorkSheet is the active WorkSheet which is not necessarly always the case. Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Sheet1" Then MsgBox " Printing Cancelled!" Cancel = True End If End Sub Any ideas ? Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show date printed, updated only when worksheet printed? | Excel Discussion (Misc queries) | |||
How can I prevent file from being saved or printed in Excel? | Setting up and Configuration of Excel | |||
How to prevent editing within a specific cells? | Excel Discussion (Misc queries) | |||
Prevent Printing of Specific Cells | Excel Discussion (Misc queries) | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions |