Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. :) |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" 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. :) |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. :) "Jim Cone" wrote: 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" 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. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code ok in Excel 2003, but crashes Excel 2002 & 2000 | Excel Programming | |||
Error in Excel 2000, but not 2002 and 2003 | Excel Programming | |||
Using OWC VBA programs in excel 2000/2002/2003 | Excel Programming | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Why is it that RTD is only applicable for Excel 2002 and 2003 and not Excel 2000 | Excel Programming |