LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Set custom ToolBar Position on Excel Loads default to zero value

I am writing an Excel Add-In that creates a custom toolbar on load
whose position is saved to the registry on exit.

However, whenever I place the toolbar on the 1st or 2nd row (usually
on the same row with the Standard & Formatting Excel Toolbars), the
Top position is properly stored into the registry as Long (23), but
when the application loads again, setting the toolbar .top property to
23 results in the toolbar being set to the value of 75. This happens
even though I am setting the Toolbar with a Long value of 23.


Excel 2000
VB6

Does anybody know anything about this? Is this because I am not
allowed to place a custom (or temporary) toolbar on the same row as a
built in Excel toolbar?

-- snip --

ToolbarTop = GetSetting(RegSettings.cToolBarTop)
If Not Len(ToolbarTop) 0 Then
oBar.Top = 100
End If

With oBar
.Position = ToolbarPosition
.Top = CLng(ToolbarTop)
.Left = CLng(ToolbarLeft)
.Visible = ToolbarVisibility
End With

-- snip --



Thanks,

John
 
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
Can I have more than 1 custom toolbar add-in in Excel 2007? Tracey Excel Discussion (Misc queries) 1 February 18th 10 05:48 AM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
How can I get into VBA for a custom toolbar - Excel 97 Jody[_4_] Excel Programming 5 November 6th 03 05:39 PM
toolbar position M. Excel Programming 1 September 19th 03 11:36 AM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM


All times are GMT +1. The time now is 12:03 AM.

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

About Us

"It's about Microsoft Excel"