FaceId is recognized in Excel 2003 but not in Excel 2000 and 2002

[jean grey]

Hi everyone.

I have CommandButtons created in Excel 2003 VBA with FaceId's 7168 and 7179
but when I load them in Excel 2000 and 2002, I get the runtime error, “Method
‘FaceId’ of object ‘_CommandButton’ failed". There are other buttons,
however, with lower FaceId's such as 80 (The letter 'A') that did not receive
that error.

Can anyone please tell me what is wrong? Is it because the said FaceId's are
not supported in the previous versions of Excel?

Thanks in advance.

 

[Jim Cone]

With each release of Excel, additional Face ID's were added.
I just checked XL2002 and the last ID is 7099.
For XL2000 the last available ID is 5682.

I can send you my free Excel add-in "Display Face ID's" that
allows you to scroll thru a display of all the ID's from the running
Excel version. Just email me and ask for it.
Remove XXX from my email address... james.coneXXX at comcast.netXXX
Please include your real name and geographic location.
--
Jim Cone
Portland, Oregon USA



"jean grey"
<[email protected]>
wrote in message
Hi everyone.
I have CommandButtons created in Excel 2003 VBA with FaceId's 7168 and 7179
but when I load them in Excel 2000 and 2002, I get the runtime error, “Method
‘FaceId’ of object ‘_CommandButton’ failed". There are other buttons,
however, with lower FaceId's such as 80 (The letter 'A') that did not receive
that error.
Can anyone please tell me what is wrong? Is it because the said FaceId's are
not supported in the previous versions of Excel?
Thanks in advance.

 

[jean grey]

Hi, Jim.
Thanks a lot for that explanation. I think I'll just use customized icons
using LoadPicture() instead of using FaceId's so I won't have troubles with
other Excel versions.