The main reason is to improve the user interface
I have a SpinButton & a CommandButton control on a particular worksheet (not
my Buttons sheet) which reconfigures the presentation of certain columns
dynamically. The cmdButton is the "DoIt" button; the spinner sets the
options...
the user spins up/down through various options which change the "DoIt"
caption to show what will happen when they click DoIt.
It's wordy to describe, but very easy to see and use.
I find the Toolbar interface more clunky (& restrictive on size of control
in a custom toolbar), but it is an option I'm considering if all else fails.

And anyway, my question still stands:
-Is there a bug in Excel around this issue?
-What is going on?
If we understand we can produce better products with less pain

spilly


"GS" wrote in message ...
After serious thinking spilly39 wrote :
My app has some ActiveX controls placed on a few worksheets as a friendly
way of invoking macros and/or Forms. e.g. my Buttons sheet (hence my UG
name) has several option buttons and a nice big Go button.

Just curious, Graham.., why would you not create a toolbar for your app
instead of putting controls on worksheets?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc