Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default FaceId is recognized in Excel 2003 but not in Excel 2000 and 2002

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default FaceId is recognized in Excel 2003 but not in Excel 2000 and 2002

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default FaceId is recognized in Excel 2003 but not in Excel 2000 and 2

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code ok in Excel 2003, but crashes Excel 2002 & 2000 tomgreen1000 Excel Programming 5 July 6th 07 07:46 AM
Error in Excel 2000, but not 2002 and 2003 Ctech[_132_] Excel Programming 1 April 3rd 06 12:44 PM
Using OWC VBA programs in excel 2000/2002/2003 [email protected] Excel Programming 0 August 23rd 05 10:04 AM
Can you use excel 2003 version with excel 2002 and 2000 on a netw. cct Excel Discussion (Misc queries) 1 January 19th 05 12:11 AM
Why is it that RTD is only applicable for Excel 2002 and 2003 and not Excel 2000 Krish[_3_] Excel Programming 2 November 21st 03 09:11 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"