Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default Floating toolbar Q - is there a limit to # of icons we can display/use?

Is there a limit to how many icons we can display on a floating toolbar?
For some reason, I'm having trouble past 4. There are other issues, but
wondering re maximum.

I don't need a ton, but I'd like to be able to have a toolbar that has about
8 buttons in total. (The next issue depends on the answer re the limit.)

Thanks! :oD


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Floating toolbar Q - is there a limit to # of icons we can display/use?


Hello StargateFanFromWork,

There probably is a limit, but it is well beyond anything you could
use. I have put several hundred controls on a Toolbar with no problem,
to display face IDs. You should post your code for review. Something is
wrong.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495371

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default Floating toolbar Q - is there a limit to # of icons we can display/use?

On Wed, 21 Dec 2005 18:42:56 -0600, Leith Ross
wrote:


Hello StargateFanFromWork,

There probably is a limit, but it is well beyond anything you could
use. I have put several hundred controls on a Toolbar with no problem,
to display face IDs. You should post your code for review. Something is
wrong.


Thank you!

Once I knew that there wasn't a limit for floating toolbar icons that
I'd get to any time soon, that confirmed to me that something was
indeed wrong with my code, as you say. I went back and broke the
whole thing down and figured out in the process how to handle working
with so much code ina systematic way.

I separated the code by many blank lines and added a partial comment
at the beginning of each chunk. Only once code worked did I fill out
the comment and erase the blank lines, moving the working lines back
up to the body of the rest of the vb code. That made it easy to
figure out each step. In this way, then, I re-built the toolbar and
find it seems to be working just fine now and all icons are being
displayed. I must have had conflicting code somewhere/somehow that
prevented some icons from being displayed and from working.

So kewl. Another enhanced workbook to use at the office. We're
streamlining more and more each day and reducing risks of error while
getting faster! I'm very grateful for all the help.

Thanks!

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495371


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
Toolbar icons candrus Setting up and Configuration of Excel 1 June 2nd 06 06:33 PM
Toolbar icons Weece Excel Discussion (Misc queries) 1 May 21st 06 12:20 PM
Floating toolbar and floating comment? StargateFan[_3_] Excel Programming 2 December 5th 05 10:26 PM
Floating Toolbar Dave Excel Discussion (Misc queries) 4 April 29th 05 04:57 PM
Display toolbar icons on form button [email protected] Excel Programming 5 March 11th 05 09:03 AM


All times are GMT +1. The time now is 04:55 PM.

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"