Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expanding Custom Menu Items

Status
Not open for further replies.
kkawano

kkawano

Programmer
Oct 22, 2002
17
US
Hi All,

In Microsoft Excel, there is an method to keep particular menus expanded. By calling

CommandBars("File").AdaptiveMenu = False

you can keep the File menu in Excel from hidding unused menu items.


Question: We have been able to do this with the built in menus. Any way to do this with custom Menus. We get an automation error when attempting this.

Thanks,

Karl
 
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
629
kapok1
kapok1
MattGreer
  • Locked
  • Question
Create Custom Ribbion - Basics 5
Replies
15
Views
625
MattGreer
MattGreer
JasonEnsor
  • Locked
  • Question
Removing Custom Ribbon when saving to Macro Free Workbook
Replies
0
Views
184
JasonEnsor
JasonEnsor
feipezi
  • Locked
  • Question
How to refresh embedded items on an Excel 2013 worksheet?
Replies
1
Views
229
kjv1611
kjv1611
remeng
  • Locked
  • Question
.CustomDocumentProperties Save Only question
Replies
8
Views
452
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top