LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Disable Print button & pulldown menu

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Preview Button in Print Dialog Box Ryan H Excel Programming 0 July 10th 09 03:14 PM
creating a pulldown based on the value of another pulldown menu kami Excel Programming 1 September 11th 08 05:50 PM
How To Disable The File, Print... And The Print Button Functions Andy Excel Programming 6 July 12th 08 01:04 AM
Disable Setup button on Print Preview screen Jon Ley Excel Programming 3 December 3rd 07 09:22 AM
Disable Print Button In a Single Workbook Hambone Excel Programming 0 January 31st 04 12:31 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"