ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Position menubar (https://www.excelbanter.com/excel-programming/344814-position-menubar.html)

René[_2_]

Position menubar
 
Hi,

I've created a menubar. When Excel opens this bar is placed at top right
position using (Position:=msoBarTop). But when I move it to a different
position, this new position isn't remembered, because everytime Excel opens
the orginal position is used.
How can I maken sure that the last given position is remembered?

thanks
René

Bob Phillips[_6_]

Position menubar
 
René,

You can't, you need to position it in the correct position. Look at the
RowIndex property of the commandbar control.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"René" wrote in message
...
Hi,

I've created a menubar. When Excel opens this bar is placed at top right
position using (Position:=msoBarTop). But when I move it to a different
position, this new position isn't remembered, because everytime Excel

opens
the orginal position is used.
How can I maken sure that the last given position is remembered?

thanks
René





All times are GMT +1. The time now is 10:45 AM.

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