Sorry Bob!

my bad...

--
steveB

Remove "AYN" from email to respond
"Bob Phillips" wrote in message
...
No, only if you want to retrieve the result, as in a function, do you need
that.

"STEVE BELL" wrote in message
news:y2Ere.3855$yw4.737@trnddc09...
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