M
mooresk257
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
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