Disable Printing
 

Hi,

I have a sheet that i need to be save it before it can be printing.

can we disable print? until the sheet has been saved it?

I have a nice button/macro that save, send and print the data on
this sheet but the user can print it anyways.

thnks

Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "Must Save Sheet!!!!"
Cancel = True
End Sub

thnks




"JOHN SMITH" <NEW wrote in message
...
Hi,

I have a sheet that i need to be save it before it can be printing.

can we disable print? until the sheet has been saved it?

I have a nice button/macro that save, send and print the data on
this sheet but the user can print it anyways.

thnks

Something like...

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Me.Saved Then
'do nothing
Else
MsgBox "Must Save Workbook!!!!"
Cancel = True
End If
End Sub




JOHN SMITH wrote:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "Must Save Sheet!!!!"
Cancel = True
End Sub

thnks

"JOHN SMITH" <NEW wrote in message
...
Hi,

I have a sheet that i need to be save it before it can be printing.

can we disable print? until the sheet has been saved it?

I have a nice button/macro that save, send and print the data on
this sheet but the user can print it anyways.

thnks




--

Dave Peterson