Restrict Print Until Some Conditions are made

[zeets84]

Good Afternoon Mates!

I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved.

Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read only mode, he can type on a cell but can not save it (since the "Save as" option is made disabled by macros). Here the trouble begins if the Read-Only-User changes any value of a cell, and take the prints. Can anyone help me?

Thanks in advance...
Regards,
Zeets

 

[sijpie]

In the ThisWorkbook module ( in the VBA editor double-click on ThisWorkbook in the top left window) you can select a Before print event sub

Private Sub Workbook_BeforePrint(Cancel As Boolean)


End Sub

Here you can make checks to ensure all the data is filled out. If it is not filled out you set Cancel to true, which means it will cancel the user request to print

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    ' Do the checks to make sure all data is filled out
   ....
   If MyCheck = false then 
      MsgBox "You cannot print until all the required data is filled out"
      cancel = true
   End If
End Sub