Disabled print toolbar and menu but Print Macro button cannot print also...

Hi,

I'm trying to make everybody print from my Print micro button where it's also able to show print dialog box. But when I test to print it cannot print and the same message box appear as my disabled print menu message appear.

Please help me.

This is my code in ThisWorkbook:

Private Sub Workbook_Open()

With Sheet2

.Protect Password:="160599", UserInterfaceOnly:=True

.EnableOutlining = True

End With
End Sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet3" Then Cancel = True
End Sub

This is my code in my Sheet 3 where my print command button situated:

Private Sub CommandButton1_Click()
If Application.Dialogs(xlDialogPrinterSetup).Show = True Then
ActiveWindow.SelectedSheets.PrintOut
End If
End Sub

you need to use a global variable.

And check that variable's status in the beforeprint macro.

Please Login or Register  to view this content.

Thank you for reply mehmetcik,

Just want to confirm with you before try your code, doesn't it will effect to all other excel file if I use global variable?

I try to disable the print menu for a workbook only. and for a new or other workbook the print menu should be enable.

Thank you for your kind response.

Thank you for your response Arkadi,

I will try asap. and notify when resolve.