Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block Printing of sheet
I have two worksheets, sheet1 and sheet2. Is there code to block sheet1 from
printing without having to place the print area in some distant cell and protect the sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block Printing of sheet
Hi,
Alt + F11 to open VB editor. Double Click 'This Workbook' and paste this in on the right Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = ("Sheet1") Then MsgBox "You cannot print this sheet" Cancel = True End If End Sub Mike "Shu of AZ" wrote: I have two worksheets, sheet1 and sheet2. Is there code to block sheet1 from printing without having to place the print area in some distant cell and protect the sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete the little red arrow in excell work sheet block | Excel Worksheet Functions | |||
Insert A Block of Data Into Another Sheet | New Users to Excel | |||
Printing rows in 1 block | Excel Discussion (Misc queries) | |||
Block an area of sheet from Printing? | Excel Discussion (Misc queries) | |||
Block an area of sheet from Printing? | Setting up and Configuration of Excel |