Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Error setting FaceId of CommandbarButton

I have used a value of 6136 for btn.FaceId. This works fine in Excel
2003, and I think it's OK in XL2002, but a user with XL2000 is
reporting Error 80004005. I got them to change it to a smaller number
and it worked OK (except obviously they get the wrong icon).
Any idea what is causing this error?
Is there a maximum value for FaceId, that varies depending on the
version of Excel? If so, what are the limits for the different
versions?
Number 6136 isn't particularly good for what I want anyway. Can anyone
suggest a better icon for launching a tool that performs various types
of analysis to identify and label certain data points in an Excel
Chart?

Thanks
Phil.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Error setting FaceId of CommandbarButton

Hi Phil,

There is substantial disparity in the range of faceids between xl2k and
latest versions.


--
Regards,
Norman



wrote in message
ups.com...
I have used a value of 6136 for btn.FaceId. This works fine in Excel
2003, and I think it's OK in XL2002, but a user with XL2000 is
reporting Error 80004005. I got them to change it to a smaller number
and it worked OK (except obviously they get the wrong icon).
Any idea what is causing this error?
Is there a maximum value for FaceId, that varies depending on the
version of Excel? If so, what are the limits for the different
versions?
Number 6136 isn't particularly good for what I want anyway. Can anyone
suggest a better icon for launching a tool that performs various types
of analysis to identify and label certain data points in an Excel
Chart?

Thanks
Phil.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Error setting FaceId of CommandbarButton

Phil,

I use #2138 in my "Chart Data Labels" program.
Also, #2128 looks usable.
At times, I have spent much effort finding the right icon;
however, I doubt if it really makes much difference to the user.

"Chart Data Labels" xl Add-in available -free- upon direct request.
Adds linked formatted data labels to a chart series;
moves or positions labels.
Remove xxx from my email address.

Regards,
Jim Cone
San Francisco, USA
XX


wrote in message
ups.com...
I have used a value of 6136 for btn.FaceId. This works fine in Excel
2003, and I think it's OK in XL2002, but a user with XL2000 is
reporting Error 80004005. I got them to change it to a smaller number
and it worked OK (except obviously they get the wrong icon).
Any idea what is causing this error?
Is there a maximum value for FaceId, that varies depending on the
version of Excel? If so, what are the limits for the different
versions?
Number 6136 isn't particularly good for what I want anyway. Can anyone
suggest a better icon for launching a tool that performs various types
of analysis to identify and label certain data points in an Excel
Chart?
Thanks
Phil.


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Error setting FaceId of CommandbarButton

Thanks Jim,

2138 & 2128 look like possibilities. I was also considering 435.
Thanks for the offer of your code. I wasn't planning on changing the
code for labelling the points (this was written years ago (in VB6) and
still seems to be working OK at the moment) I've just recently added a
toolbar in another project which was causing this particular problem. I
may well be doing some work in this area in the near future though, so
I may be in touch about taking a peek at your addin.

Cheers,
Phil.

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
Self deleting CommandBarButton possible? Bruno G. Excel Programming 2 January 11th 05 12:13 PM
CommandBarButton click event Javi Excel Programming 0 November 3rd 03 03:05 PM
CommandBarButton.FaceId=? Tom Ogilvy Excel Programming 1 September 17th 03 05:28 PM
Thanks - creating a commandbarbutton with a custom bitmap Kris Van Baelen Excel Programming 0 July 11th 03 08:24 PM
creating a commandbarbutton with a custom bitmap Tom Ogilvy Excel Programming 0 July 11th 03 07:50 PM


All times are GMT +1. The time now is 10:31 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"