Use the Workbook_Open event to execute some code. In the ThisWorkbook
module of your VBA project write some code like this.

Private sub Workbook_Open()
Userform1.show
end sub

For the other problem I would suggest using the shell command. Shell
allows you to execute a DOS command.



furbiuzzu wrote:
Hi all,

i've 2 problems connected with the opening of an excel file that i'm
not able to solve.

I would like to:

1) have my userform1 to be automatically shown (opened) when the file
is opened from its desktop icon

2) associate with this "opening" a .wma or .mp3 file to use as
soundtrack

just 2 simple things for you, impossible for me.

thanks in advance for your (quick) help.