Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Toolbar icons | Setting up and Configuration of Excel | |||
Toolbar icons | Excel Discussion (Misc queries) | |||
Floating toolbar and floating comment? | Excel Programming | |||
Floating Toolbar | Excel Discussion (Misc queries) | |||
Display toolbar icons on form button | Excel Programming |