Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable print from standard toolbar button
Hi Folks,
I have a workbook where I want users to be able to print only from the print controls I have on the worksheets. I have disabled all the print controls using: Private Sub Workbook_Activate() Dim Ctrl As Office.CommandBarControl For Each Ctrl In Application.CommandBars.FindControls(ID:=4) 'print Ctrl.Enabled = False Next Ctrl End Sub However, the print button on the standard toolbar is still active. How do I disable this too? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable print from standard toolbar button | Excel Programming | |||
How do I replicate a macro for each button on standard toolbar? | Excel Discussion (Misc queries) | |||
How do I duplicate a macro for a button on the Standard Toolbar? | Excel Discussion (Misc queries) | |||
How to get Research button on my standard toolbar? | Excel Discussion (Misc queries) | |||
Fax Button on Standard Toolbar | Excel Discussion (Misc queries) |