Command Bars
Hello,
Is there a way to control where a command bar is placed when you add one. I have a sheet that, when activated, a command bar is added. I want it to be in the upper left hand corner of the worksheet. Thanks. Bill |
Command Bars
There are a couple properties involved:
..Position sets the location, meaning will it be among the bars at the top, left, right, or bottom of the screen, or is it floating or a meu bar. ..RowIndex determines its priority within its group: the lowest RowIndex becomes the leftmost; you can also use msoBarRowFirst to force it to become the first priority -- - K Dales "Bill" wrote: Hello, Is there a way to control where a command bar is placed when you add one. I have a sheet that, when activated, a command bar is added. I want it to be in the upper left hand corner of the worksheet. Thanks. Bill |
All times are GMT +1. The time now is 04:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com