Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable print function on current workbook
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable print function on current workbook
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" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable print option of a worksheet/workbook | Excel Discussion (Misc queries) | |||
Can you disable the save function from a shared workbook | Excel Discussion (Misc queries) | |||
How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Disable Print Button In a Single Workbook | Excel Programming |