Thanks Tom,

Am using Office 2000....so bad luck for me



Tom Ogilvy Wrote:
What version of excel. I believe this is only supported in xl2003
(perhas
2002).

--
Regards,
Tom Ogilvy


"micmacuk" wrote:


Hello,

I am writing a custom toolbar and I wish to assigne a picture to one
of
the control button but my syntax doesn't work. It bugs on .Picture=

Could someone help ?


Set cb = Application.CommandBars.Add(Name:="ToolBar1",
temporary:=True)


With cb
Set cbpop = .Controls.Add(Type:=msoControlButton, temporary:=True)
With cbpop
.Picture = LoadPicture("C:\STOCK
CONTROL\Data-Macro\ArrRedLeftPlain.bmp")
.OnAction = ThisWorkbook.Name & "!Macro_Vide"
End With
End With

Cheers
Francois


--
micmacuk

------------------------------------------------------------------------
micmacuk's Profile:
http://www.excelforum.com/member.php...o&userid=33253
View this thread:
http://www.excelforum.com/showthread...hreadid=546771




--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: http://www.excelforum.com/member.php...o&userid=33253
View this thread: http://www.excelforum.com/showthread...hreadid=546771