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


    PLEASE HELP!!
    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....


    Code
    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.