Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu bar location
I have created a menu bar upon opening a workbook.
What vb do I use to place it somewhere. I.e. I would like to place it either next to the 'standard' menu bar or beneath it. How do I do this? Thanks in advance Matthew Balch |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu bar location
Look at the position and rowindex properties of the commandbar object in
help. For example Application.CommandBars.Add(Name:="myMenuBar", Position:=msoBarTop, _ MenuBar:=False) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Matthew Balch" wrote in message ... I have created a menu bar upon opening a workbook. What vb do I use to place it somewhere. I.e. I would like to place it either next to the 'standard' menu bar or beneath it. How do I do this? Thanks in advance Matthew Balch |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu bar location
Thanks Bob
"Bob Phillips" wrote: Look at the position and rowindex properties of the commandbar object in help. For example Application.CommandBars.Add(Name:="myMenuBar", Position:=msoBarTop, _ MenuBar:=False) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Matthew Balch" wrote in message ... I have created a menu bar upon opening a workbook. What vb do I use to place it somewhere. I.e. I would like to place it either next to the 'standard' menu bar or beneath it. How do I do this? Thanks in advance Matthew Balch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Inserting after specific location on right click menu | Excel Discussion (Misc queries) | |||
Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
placing a pull-down menu at a cell location automatically | Excel Programming |