sending workbook in email

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
I created a form for my coworkers to use to submit requests. I have everything complete (all combo boxes work, a reset button...yada yada) but I wanted to have the Workbook_Open call the Reset_Click event and also by using a Submit button, have the form emailed from the user to me. Any ideas?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
Thanks Smitty. Any ideas on calling the Reset_Click event in the Workbook_Open event???
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Any ideas on calling the Reset_Click event in the Workbook_Open event???
When I have to do that I generally put the button code in a general module and call it in both places.I.E.
Code:
Private Sub Workbook_Open()
  Application.Run "Reset_Code"
End Sub

Private Sub Reset_Click()
  Application.Run "Reset_Code"
End Sub
Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,118,086
Messages
5,570,136
Members
412,305
Latest member
Mozz
Top