(Msg. 2) Posted: Wed Jun 11, 2008 8:55 pm
Post subject: Re: deactivate printing [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Add some event code to Thisworkbook.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Application.CountA(Sheets("Sheet1").Range("A1:C1")) < 3 Then
Cancel = True
MsgBox "Please fill required cells, print has been cancelled"
End If
End Sub
Gord Dibben MS Excel MVP
On Wed, 11 Jun 2008 13:28:01 -0700, Smulli <Smulli.RemoveThis@discussions.microsoft.com>
wrote:
>How can prefent a document to be printed when specific cells are not filled?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office