> FSt1,
>
> Thank you that made the floating bar. I have two problems though.
> 1. How do you get the floating Command Bar to start up automaticly when
> entering this file?
Include the code that builds the command bar into the Workbook_Open event
procedure in the ThisWorkbook code module, or call a startup procedure from
this event procedure.
> 2. How do I get the buttons to automaticly associate with their designated
> macro.
[quoted text clipped - 4 lines]
> would automaticly run that macro once the button is clicked. Why is it not
> working?
Does the procedure not get called, or get called but not run? Put a
breakpoint inside the sub to see if code ever stops there.
You could make it more likely to find the right sub:
.OnAction = "'" & ThisWorkbook.Name & "'!Scroll31Right"
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
Don Lowe - 13 May 2008 15:02 GMT
Jon,
Currently, I am having to click a button to run the macro for the floating
command bar. I would like it to appear automaticly when opening this file.
By the way thank you for the code that portion works now.
> Does the procedure not get called, or get called but not run? Put a
> breakpoint inside the sub to see if code ever stops there.
[quoted text clipped - 9 lines]
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
Jon Peltier - 13 May 2008 19:34 GMT
With the workbook open, right click the Excel icon to the left of the File
menu, and choose View Code. This opens the "ThisWorkbook" code module for
the open workbook. Select the Workbook object in the left dropdown. The Open
method is selected in the right dropdown, and this procedure shell appears
in the code module:
Private Sub Workbook_Open()
End Sub
When the workbook open event occurs (i.e., the workbook is opened), this
event procedure runs. Place the menu creation code within it, or better,
call the menu creation procedure from here:
Private Sub Workbook_Open()
MakeMyMenu
End Sub
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
> Jon,
>
[quoted text clipped - 16 lines]
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______