Setting Custom Icons at Run-time

[DNF Karran]

You cannot edit them as you would manually but you can save your image
as pictures in your workbook, perhaps on hidden
sheets, then do copy and pasteface when you create your menus wit
code.

Dunca

 

[Bob Phillips]

Syed,

It doesn't really matter what file type they are as you will load them into
the Excel sheet (Insert>Picture>From File), and name them. To add them to
the toolbar, use

cbTable.Shapes(shapename).CopyPicture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Thanks, Duncan!

I like the idea of saving images on hidden sheets. But what should be the
format of these images *.bmp, *.ico, *.gif or what?
And how would I copy an image from a sheet?

Thank you,
--
Syed Zeeshan Haider



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com


in message

 

[Syed Zeeshan Haider]

Hello Experts,
I have Excel 97 Pro on Win98SE.

If there is a custom toolbar in Excel with some buttons, then is it possible
to set them custom icons programmatically?

I have searched through the Excel Help but all in vain.

Thank you,

 

[Syed Zeeshan Haider]

Thanks, Duncan!

I like the idea of saving images on hidden sheets. But what should be the
format of these images *.bmp, *.ico, *.gif or what?
And how would I copy an image from a sheet?

Thank you,
--
Syed Zeeshan Haider



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com


in message
news[email protected]...

 

[Syed Zeeshan Haider]

Thanks, Bob!

Now I am starting my project again. I hope I'll succeed.

Thanks again!
--
Syed Zeeshan Haider



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com

Syed,

It doesn't really matter what file type they are as you will load them into
the Excel sheet (Insert>Picture>From File), and name them. To add them to
the toolbar, use

cbTable.Shapes(shapename).CopyPicture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)