D
Don Wiss
My application requires the users to use PasteSpecial Values to paste in
data. Due to there being eight Citrix servers, and a lot of users, I'd like
my workbook to add this button if it isn't already on the toolbar. This
line of code:
Application.CommandBars("Standard").Controls.Add Type:=msoControlButton, ID:=370, Before:=11
puts it before the 11th button. But I'd like to put it right after the copy
button. Plus I don't want to add one if it already exists someplace on the
Standard toolbar. And if the Standard toolbar doesn't exist then don't do
anything.
I gather I have to loop through the toolbar items to see whether
PasteSpecial Values is already present, and to find the position of the
Copy button. But this is where I got lost.
Don <www.donwiss.com> (e-mail link at home page bottom).
data. Due to there being eight Citrix servers, and a lot of users, I'd like
my workbook to add this button if it isn't already on the toolbar. This
line of code:
Application.CommandBars("Standard").Controls.Add Type:=msoControlButton, ID:=370, Before:=11
puts it before the 11th button. But I'd like to put it right after the copy
button. Plus I don't want to add one if it already exists someplace on the
Standard toolbar. And if the Standard toolbar doesn't exist then don't do
anything.
I gather I have to loop through the toolbar items to see whether
PasteSpecial Values is already present, and to find the position of the
Copy button. But this is where I got lost.
Don <www.donwiss.com> (e-mail link at home page bottom).