Disable print from standard toolbar button

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top