i am loading data out of Sharepoint in an Ecxel file. on opening the Excel file a userForm1 will be displayed with UserForm1.show and this will ask users for input.

after the code was executed the user can email the file as an attachment....File -> Send -> EMail.

After the mail was send the user can then click on a Button on the worksheet to load the UserForm1 again in order to run another report.


The problem that i am facing is that the UserForm1 does not load and i receive an error - Run Time error 75 - could not find the object.

with both Load Userform1 and UserForm1.show i receive the error.

hope somebody can help me with this issue please.

Thanks
Cornie