Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get floating CommandBar position
After I manually move my custom command bar to the place I want it, is there
a command I can type in the immediate window to get the .Top and .Left positions? Thanks, Patti |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get floating CommandBar position
"Patti" wrote in message
... After I manually move my custom command bar to the place I want it, is there a command I can type in the immediate window to get the .Top and .Left positions? Hi Patti, Here's one way to do it: ? CommandBars("YourBarName").Top ? CommandBars("YourBarName").Left -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get floating CommandBar position
Hi Rob,
When I try that, I get a compile error: "Expected variable or procedure, not module". I have tried both ? commandbars(myapp).top and ? commandbars("My Toolbar").top. Partial code - pinched from Bob Phillips - follows. Any ideas? Thanks! Patti Private Sub Workbook_Open() 'Bob Phillips Dim oCB As CommandBar appMenu = "My Toolbar" On Error Resume Next Application.CommandBars(appMenu).Delete On Error GoTo 0 Set oCB = Application.CommandBars.Add(Name:=appMenu, Position:=msoBarFloating, temporary:=True) With oCB With .Controls.Add(Type:=msoControlButton) .Caption = appMenu & " Toolbar" .Style = msoButtonCaption End With '. '. ' more controls added '. .Visible = True End With End Sub "Rob Bovey" wrote in message ... "Patti" wrote in message ... After I manually move my custom command bar to the place I want it, is there a command I can type in the immediate window to get the .Top and .Left positions? Hi Patti, Here's one way to do it: ? CommandBars("YourBarName").Top ? CommandBars("YourBarName").Left -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get floating CommandBar position
Did you try Rob's suggestion after you ran Bob's code?
I included Rob's suggestion into Bob's code and it still worked. Option Explicit Private Sub Workbook_Open() 'Bob Phillips Dim oCB As CommandBar Dim appMenu As String appMenu = "My Toolbar" On Error Resume Next Application.CommandBars(appMenu).Delete On Error GoTo 0 Set oCB = Application.CommandBars.Add(Name:=appMenu, _ Position:=msoBarFloating, temporary:=True) With oCB With .Controls.Add(Type:=msoControlButton) .Caption = appMenu & " Toolbar" .Style = msoButtonCaption End With '. '. ' more controls added '. .Visible = True MsgBox .Top & vbLf & .Left End With End Sub Patti wrote: Hi Rob, When I try that, I get a compile error: "Expected variable or procedure, not module". I have tried both ? commandbars(myapp).top and ? commandbars("My Toolbar").top. Partial code - pinched from Bob Phillips - follows. Any ideas? Thanks! Patti Private Sub Workbook_Open() 'Bob Phillips Dim oCB As CommandBar appMenu = "My Toolbar" On Error Resume Next Application.CommandBars(appMenu).Delete On Error GoTo 0 Set oCB = Application.CommandBars.Add(Name:=appMenu, Position:=msoBarFloating, temporary:=True) With oCB With .Controls.Add(Type:=msoControlButton) .Caption = appMenu & " Toolbar" .Style = msoButtonCaption End With '. '. ' more controls added '. .Visible = True End With End Sub "Rob Bovey" wrote in message ... "Patti" wrote in message ... After I manually move my custom command bar to the place I want it, is there a command I can type in the immediate window to get the .Top and .Left positions? Hi Patti, Here's one way to do it: ? CommandBars("YourBarName").Top ? CommandBars("YourBarName").Left -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get floating CommandBar position
"Patti" wrote in message
... Hi Rob, When I try that, I get a compile error: "Expected variable or procedure, not module". I have tried both ? commandbars(myapp).top and ? commandbars("My Toolbar").top. Hi Patti, It sounds like you've named one of your code modules CommandBars. This is confusing VBA because it thinks you're trying to reference a procedure in that module. Rename the module to something like MCommandBars and try it again. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandBar | Excel Programming | |||
Adjust position of a commandbar | Excel Programming | |||
commandbar | Excel Programming | |||
commandbar hunt | Excel Programming | |||
Moving CommandBar using VBA or C# | Excel Programming |