This Worked for me in Excel 2000

Dim x

x = Application.Run("personal.xls!bottomrow")

seems like it needs to start with
variable =
--
steveB

Remove "AYN" from email to respond
"Jan" wrote in message
...
I'm a novice at VBA. I want an add-in data form to display when the
workbook
is opened. I have the following code, but nothing happens when the
workbook
is opened. I still have to manually select Data from the menu followed by
selecting the add-in form from the drop down list to display the form on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA