View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PATS PATS is offline
external usenet poster
 
Posts: 17
Default Prevent Printing

My code below is designed to lockdown my workbook if the user selects Read
Only. What I am wondering, is there any way to also prevent them from
printing the document?


Private Sub CommandButton1_Click()

On Error GoTo Termination

If Me.OptionButton1.Value = True Then
myLocked = True
Unload UserFormAccess
Call Protection.protect_all_sheets
ElseIf Me.OptionButton2.Value = True Then
myLocked = False
Unload UserFormAccess
UserFormPassword.Show
End If

GoTo LastLine

Termination:

LastLine:

End Sub