|
Anthony's VBA Forum Where the knowledge is shared |
|
|
View previous topic :: View next topic |
Author |
Message |
totr1
Joined: 20 Aug 2008 Posts: 4
|
Posted: Wed Aug 20, 2008 5:52 am Post subject: Workbook_Open |
|
|
Hi
In the add_in (*.xla) this code is in "ThisWorkbook":
Private Sub Workbook_Open()
UserForm1.Show 'Welcome
End Sub
And the UserForm1-code is:
Private Sub UserForm_Click()
Unload Me
End Sub
Works fine as an *.xls-file. But as an Add_in (*.xla), my file (ie. MyFile.xls) won't open (must opened MyFile.xls with a second try).
What am I doing wrong?
Kind regards |
|
Back to top |
|
|
totr1
Joined: 20 Aug 2008 Posts: 4
|
Posted: Wed Aug 20, 2008 6:20 am Post subject: Workbook_Open |
|
|
Appendix: Works fine opening excelfiles downloaded and opened from the web. But not opening the files from my directory.
t |
|
Back to top |
|
|
mohan.ankur Moderator
Joined: 02 Aug 2006 Posts: 52
|
|
Back to top |
|
|
totr1
Joined: 20 Aug 2008 Posts: 4
|
Posted: Wed Aug 20, 2008 11:55 am Post subject: |
|
|
The Workbook_Open/Add_In works allright. However, I start Excel why I would like to open/click on "MyFile.xls". Excel starts, Add_In opens as expected, but "MyFile.xls" is does not open. The Excel is started without any sheets visible.
Or put it in an other way, when the Add_In starts with a UserBox1 "Welcome", the file (ie. MyFile.xls) does not open. Only Excel and the Add_In start.
In advance, thank You.
t |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|