Hi,

I am new here and I am not sure if this issue has been brought u
before. If so, please let me know.

Basically, I am looking to record a simple macro whereby, pressing th
button, it will insert your name into a cell and date it. Thereafter
it will automatically email out to the next designated person. Thi
normally used in electronic forms.

My questions a-

1. How do I tell Excel to capture the login name of Windows as the nam
to be inserted into the cell?

2. How can I create in a way that Excel will prompt out a bo
requesting you to key in your name but the user will not allow to amen
or key in directly into the cell (as I intend to lock protect tha
cell). In another word, the key in box would act as input field.

3. How do I record a Macro which include auto emailing with th
predefined email address in the macro?

I am not familiar with Macros nor VBA...so, I expect a more detaile
help as well as the easiest way to do it, say through normal recordin
of Macros rather than we have to type everything ourselve.

Please help me....

--
Message posted from http://www.ExcelForum.com