I need to be able to disable the print function for the current workbook
only, but I still want the print macro that I wrote to work. If the print
function is used without using the print macro, it'll print out 100 pages.

Thanks!

Hi AvalancheMike

You can use this event in the thisworkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

Then in you macro use EnableEvents

Sub test()
Application.EnableEvents = False
ActiveSheet.PrintOut
Application.EnableEvents = True
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl



"AvalancheMike" <(E-Mail Removed)> wrote in message
news:5C726498-7E97-44DD-81D6-(E-Mail Removed)...
>I need to be able to disable the print function for the current workbook
> only, but I still want the print macro that I wrote to work. If the print
> function is used without using the print macro, it'll print out 100 pages.
>
> Thanks!