I'm trying to add a command bar to excel.
I have the following code in Sub Auto_Open() :

tmpControl.Caption = "Workbook1"
tmpControl.OnAction = "Workbook1.xls!RunMacro"
tmpControl.Tag = "Workbook1"

I'm wanting to change the tmpControl.OnAction to open the workbook "Workbook1". I know this is set up to run the macro "RunMacro", but I'm not sure how to change it so when I click on the command bar, it will simply just open the workbook.


Any help is greatly appreciated!!

Thanks,


DejaVu