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.
Thanks rem1224. I had thought of this, but thought that disabling the print button would be more 'proactive'.
I'll go with your suggestion, thanks
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....
Application.CommandBars("Standard").Controls("Print (\\NPR0042SFO\H4130SFO)").Enabled = FalseHere, 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.