View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Can I make my own FaceID's?

Yes, using any icon editor, you can build your own. You can either copy to
the clipboard and then paste to an existing button, or in VBA, copy it to a
worksheet, and assuming its sheet1, name 'Picture 1', then just use

Worksheets("Sheet1").Pictures("Picture 1").Copy
oButton.PastFace

I think you are limited to 16x16.

---

HTH

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

"TBA" wrote in message
...
Excel 2000
Windows 2k Pro

Can I make my own customized FaceID's? If so, can they be 32x32? And

where
would they need to be saved?

TIA.

-gk-