Need help disabling users from printing unless they print with a given macro button

[TylerR99]

I'm rather new to using VBA and was looking for some help. The issue I'm having currently is that we have a sheet that users input data into, then once complete there is a macro that they can use to print. The macro prints 3 copies and transfers the given data into a log. However users are not using the provided macro and rather just pressing file and printing there or Ctrl+P. Now this bypassed the macro and makes it so the data does not get saved into the log. What can I do using VBA to solve this? Can I disable printing unless the given macro is used? Or is there a way I can add a popup menu that instructs the user to press the macro instead?

 

[mikerickson]

You could put this in the ThisWorkbook code module

' in ThisWorkbook code module

Public PrintViaMacro As Boolean

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    If Not PrintViaMacro Then
        Cancel = True
        MsgBox "Print this file using the macro"
    End If
    PrintViaMacro = False
End Sub

And then modify your existing print macro just a bit.

Sub myPrintMacro()
    ' do stuff
    
    ThisWorkbook.PrintViaMacro = True: Rem add this line <<<<<<<<<<<<<
    ActiveSheet.PrintOut
    
    ' do more stuff
End Sub

 

[TylerR99]

That worked exactly like I needed thanks. Would there be a way that I could cause that to affect only one sheet?