PDA

View Full Version : Emailing userForm as attachment



bstester
02-17-2006, 10:34 AM
I have created a userform that automatically displays when the document is opened. It works when I open it on my box. However, it won't automatically open when emailed as an attachment. Why and how can I fix this?

This is the code that I used to automatically pop the userform when the document is opened.

Private Sub Document_Open()
UserForm1.Show
End Sub


Thanks

boneKrusher
02-17-2006, 12:55 PM
It might be because the person receiving the doc has their Macro Security on High.... just a guess.

bstester
02-17-2006, 01:15 PM
We checked the security settings and they are fine. Anyone have any other ideas?

boneKrusher
02-18-2006, 05:44 AM
can you attach a sample to the thread? I can look at it....
Bones