ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Partitions in Short Cut menues (https://www.excelbanter.com/excel-programming/391453-partitions-short-cut-menues.html)

ZipCurs

Partitions in Short Cut menues
 
I am having good success using custom short cut menus, but I have one
aesthetic question. How do I get the partition lines like on the default
menu? (Like above and below "Insert Comment".

Thanks in advance.

ZipCurs

Jim Cone

Partitions in Short Cut menues
 

Set NewMenuItem = .Add(msoControlButton)
NewMenuItem.BeginGroup = True
-or-
Application.CommandBars("Cell").Controls(3).BeginG roup = True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins: compare, uniques, color sort, thesaurus,...)



"ZipCurs"
wrote in message
I am having good success using custom short cut menus, but I have one
aesthetic question. How do I get the partition lines like on the default
menu? (Like above and below "Insert Comment".
Thanks in advance.
ZipCurs

ZipCurs

Partitions in Short Cut menues
 
Jim,

Thank you. That was exactly what I needed.

"Jim Cone" wrote:


Set NewMenuItem = .Add(msoControlButton)
NewMenuItem.BeginGroup = True
-or-
Application.CommandBars("Cell").Controls(3).BeginG roup = True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins: compare, uniques, color sort, thesaurus,...)



"ZipCurs"
wrote in message
I am having good success using custom short cut menus, but I have one
aesthetic question. How do I get the partition lines like on the default
menu? (Like above and below "Insert Comment".
Thanks in advance.
ZipCurs



All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com