Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can harness the Workbook_BeforePrint event to do this (I use it
extensively). In the Workbook_BeforePrint Sub, you set "Cancel = True" to prevent printing if the value of a Public variable is False. In any other Subs of yours that invoke a Print, you set that Public variable to True (you also reset it to False at the end of those Subs). Thus, the print will only proceed if it has been invoked by a Sub that is called by your print button(s) -- Time is just the thing that keeps everything from happening all at once "Rich" wrote: I'd like to disable the print button in the "standard" toolbar - and maybe even in the pull-down menu, too - in favor of a custom print button in my custom toolbar. I'm not sure how to go about it... Anyone have any ideas?? TIA. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable Preview Button in Print Dialog Box | Excel Programming | |||
creating a pulldown based on the value of another pulldown menu | Excel Programming | |||
How To Disable The File, Print... And The Print Button Functions | Excel Programming | |||
Disable Setup button on Print Preview screen | Excel Programming | |||
Disable Print Button In a Single Workbook | Excel Programming |