Disable only the Print Button. NOT File -> Print,or Print Preview

[longstick]

I've tried search the web looking for an answer and hoping I wouldn't have to post here. Its too easy to just post a question and have someone fix it for me.

I have a sheet that copies information to a secondary location when printed. This sheet is opened in read-only and the user won't save the workbook. The user does not see the secondary workbook. It opens, saves, and closes without the user's knowledge.

I need to disable the print button on the tool bar because they are required to print 2 or more copies of this sheet. If they hit the print button more than once than the information is copied more than once.

I would like the user to use File -> Print and then select multiple copies to be printed. Is there a way to limit the user to using File -> Print without putting a Print User Button on the actual worksheet?
Thanks

 

[drsarao]

One way to do it is by customizing the toolbar.
You can delete the "Print" button and insert "Print..." button.
You will find it in by Right click Menu bar --> Customise--> Commands ---> File... Search in the right hand pane.

This button works exactly like File-->Print, producing the dialog box for settings etc.

 

[longstick]

A Friend gave me this. The only issue would be if another user has their tool bar setup differently (from what I understand).

I was told it deactivates the print button when the required workbook is selected. It activates the print button when a different or other workbook is selected.

Private Sub Workbook_Activate()                                   
    Application.CommandBars.FindControl(ID:=2521).Enabled = False
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.CommandBars.FindControl(ID:=2521).Enabled = True
End Sub


Private Sub Workbook_Deactivate()
    Application.CommandBars.FindControl(ID:=2521).Enabled = True
End Sub


Private Sub Workbook_Open()
    Application.CommandBars.FindControl(ID:=2521).Enabled = False
End Sub