stop excel sheet from being printed

[Zambian]

like to stop other users from being able to print the first page of a workbook

 

[Sheeloo]

Use a macro like
Private Sub workbook_BeforePrint(Cancel As Boolean)

Select Case ActiveSheet.Name

Case "Sheet1", "Sheet2"

Cancel = True

MsgBox "Sorry, you cannot print this sheet from this workbook",_

vbInformation

End Select

End Sub


See
http://www.brainbell.com/tutorials/ms-office/excel/Prevent_Users_From_Performing_Certain_Actions.htm for details
(the above macro is taken from the page above)

 

[JMay]

Different interpretations of what you are asking for here -- I see it that
you are asking to "SKIP" the printing of any Page1 on say a Sheet1 that print
several pages ordinarily (say 1 to 5).. any way

Give this a shot: (In a Standard module - paste in)

Sub PrintSkipP1()
Dim sht As Worksheet
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
For Each sht In ActiveWindow.SelectedSheets
sht.PrintOut From:=2, To:=TotPages
Next sht
Set sht = Nothing
End Sub