View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Jan is offline
external usenet poster
 
Posts: 159
Default What is wrong with this code?

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