Toolbars

B

Bill

Hello,
I have a workbook that utilizes three different toolbars, depending on which
worksheet you are on. So, I build the toolbars the first time the workbook
is opened, and then either hide or show a given toolbar when a worksheet is
selected. My problem is the placement of the toolbar. I want it to be in
the upper left hand corner of a chart if the sheet is a chart; or in cell A1
if the sheet is a worksheet. Here is the code I use to play the chart:


Application.CommandBars.Add(Name:="FH", Temporary:=True).Visible =
True

With ActiveWindow
Application.CommandBars("FH").Top = .PointsToScreenPixelsY(0)
Application.CommandBars("FH").Left = .PointsToScreenPixelsX(0)
End With

The problem is that the toolbar moves around as I go from page to page. It
may start out in the right position, but then move up on the menus. Anyway
to keep it where I want it each time?

Thanks,

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top