VBA not working when assigned to a text box

[cmorten82]

So I have some VBA that when I run it in the module it works great. It attaches the workbook to the email and everything but when I assign it to a text box it only creates an email but does not attach the current workbook. Where am I going wrong?

[Norie]

How are you trying to trigger the code from the textbox?

If it's a Forms textbox on a sheet you would need to actually click the textbox.

[cmorten82]

Sorry forgot to add the code. I created a box using: insert > Shapes > Rectangle and added text to it. The box will open up an email with the "To" and "Subject" but it wont attach. if I run the code in the module it will attach.

Please Login or Register  to view this content.

[Norie]

What happens if you remove On Error Resume Next from the code and run it again?

[cmorten82]

Well now I feel kind of dumb. So there are a couple other text boxes and the one I was using was a copy and it had a hyperlink so once I right clicked on the box and removed hyperlink the VBA worked great. Sorry and Thanks!