How do you block printing in Excel 2000

[pwrgek]

I have a spread sheet and would like to block the print function when the datasheet tab is selected. Any help would be greatly appreciated. I know this is probably a very simple question but I can't seam to find the right commands.

 

[SkipVought]

Hi,

In the Workbook Before Print event

right click the sheet tab,
activate the Workbook Object --

paste...

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

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

BTW, change the SHEET NAME in the IF Statement



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[pwrgek]

Thank you that was easy.