#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default Toolbars

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Toolbars dstiefe Excel Discussion (Misc queries) 2 August 3rd 05 08:52 PM
Please Help, No Toolbars in my view-toolbars! [email protected] Excel Programming 2 February 19th 05 09:15 PM
Toolbars Edgar Thoemmes[_4_] Excel Programming 2 November 4th 04 11:51 AM
Toolbars Jay[_14_] Excel Programming 1 December 5th 03 09:26 AM
toolbars Joe 90[_2_] Excel Programming 0 November 1st 03 02:23 AM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"