asked on

Can I have the Excel Data Entry Form open on file open, then email worksheet when the form is closed?

I would like to have the Excel produced Data Entry Form open when the file is open, then once the user has entered the data and clicked on close, have the worksheet emailed to a designated email address naming the attachment using the current user's logonID.
Can I edit the data entry form that Excel creates?

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michael Spellman

ASKER

This is the code that I used. It opens the Data Entry Form. (I'd like to get rid of the warning dialog box that appears - Excel cannot determine which row...etc). Then when user closes the data entry form, it emails the active worksheet to me.

I would like to hide the workbook and just have the data entry form appear. It would also be nice if I could edit the data entry form. I suspect that I would have to switch to a userform, but dont know. Is that correct?
ENS-AltForm.xlsm

Professor J

:) by accident i opened the file and it sent two emails to one of the emails in the macro. so if you get those emails, please ignore them. i will look at your file later today in detail and see what i could possible come up with.

Michael Spellman

ASKER

Thanks for the help. If you get a chance to comment on the other aspects, let me know.