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 he

Private Sub Workbook_Open()
MakeMyMenu
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Don Lowe" wrote in message
...
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.


"Jon Peltier" wrote:


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
_______