Prev: Adding to a list of codes
Next: Update datasource links programmatically
From: mooresk257 on 2 Jun 2010 09:16
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
 | 
Pages: 1
Prev: Adding to a list of codes
Next: Update datasource links programmatically