View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IRMA MENDOSA[_2_] IRMA MENDOSA[_2_] is offline
external usenet poster
 
Posts: 2
Default BeforePrint Caption = ""

Does Any One Knows How to make this Work
Thanks In Advance




Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Cheque" Then
Application.ScreenUpdating = False
If DialogSheets("Dialpassword").Show Then
With DialogSheets("Dialpassword")
.Unprotect ("USA")
.EditBoxes(1).Caption = ""
With DialogSheets("Dialpassword")
senham = .EditBoxes(1).Caption
If senham < "your Password here" Then
MsgBox "Get a Password!", , "Mexican Furniture"
End With
End If
End With
End If
Cancel = True
End If
End Sub