Posts by RichSF

    rem1224: I tried this too, but foung that everyone's toolbar is different (my print icon is index 8). Thanks again.

    Iridium: I can't remove the toolbar because they still need to 'Save As...' after validation, and I built a custon right-click menu for the sheet. But thanks for the ideas.

    Hi All

    I'm trying to disable my 'Print' button on the toolbar, to force users to 'validate' the information on a sheet before it's printed....

    Application.CommandBars("Standard").Controls("Print (\\NPR0042SFO\H4130SFO)").Enabled = False

    Here, the command works fine, but the control name has to contain the full path of my printer to work! If this is used by someone else connected to a different printer, it will fail.

    How can I get this to work for everyone? Would I need to find the name of everyone's printer first (I would need help with this), or could I use a wildcard 'Print*'?

    Can anyone help? Thanks.