View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Custom Menus & "Begin a Group" option

I have much lower standards than you <bg.

You can write to

asking for a change.

I'm not sure I would phrase it as a "fix", though. Maybe a "reverse
enhancement"???



JMMach wrote:

You are right, I can see the begin group line when the toolbar layout is
right to left. However I would like to go top to bottom. I guess Microsoft
has "fixed" it.
So unless the begin group line color can be changed, a work-around will be
to use a menu item with a string of the "_" character, and the assigned
macro simply being an empty shell of a procedure.
Do you have any other suggestions? How do we tell Microsoft to "fix this
again"?
Thanks again.
TTFN
JMMach

"Dave Peterson" wrote in message
...
If you layout your toolbar right to left--not top to bottom, then the

begingroup
is easier to see.

With the prettiness of the dropdowns in the newer versions of excel, maybe

it's
just the builtin shading that's hiding the begingroup line.



JMMach wrote:

Sorry, I did not make my question totally clear. So let me clarify. I am
talking about a manual process, and not an automated process:
When in Excel, I open the Customize dialog box, then I attempt to modify

an
existing toolbar. I can right-click on a button or menu item in my

custom
toolbar, and select Begin a Group from the context menu, but I do not

see
any change. In Excel 2000 doing this same action would put a grey line

above
the button or menu item that was right-clicked. That is not happening in
Excel 2003.
Thanks.
TTFN
JMMach

"Chip Pearson" wrote in message
...
Just set the BeginGroup property to True.

.BeginGroup = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JMMach" wrote in message
...
With Excel 2000, we could use the "Begin a Group" command to
put a separator
line between a couple of menu items, but in Excel 2003 it does
not seem to
work. It looks like the "color scheme" of Excel 2003 "hides"
the intended
effect.
How do I successfully employ the "Begin a Group" command in
Excel 2003?
Thanks in advance.





--

Dave Peterson


--

Dave Peterson