In xl2000 you would copy the picture to the clipboard and then use pasteface
- so you migt have to import it into the worksheet first.
--
Regards,
Tom Ogilvy
"micmacuk" wrote:
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