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

Hi
have a look at
http://www.rondebruin.nl/sendmail.htm
for code examples


--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

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

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

My questions a-

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

2. How can I create in a way that Excel will prompt out a box
requesting you to key in your name but the user will not allow to
amend or key in directly into the cell (as I intend to lock protect
that 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 the
predefined email address in the macro?

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

Please help me.....


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

Hi Frank,

Thanks for the sample codes.....but as informed, I am totally new wit
VBA. So, please advise me if it is wrong, I will copy the sample code
and insert (as additional line) in the macro I recorded, correct?

How about the pop up box to fill in the name? Any code for that?
tried to protect the cell and use macro to insert a word there but wa
prompted with error for the cell is protected. How can we enable th
macro to insert something into the protected cells without unprotectin
the whole worksheet? Can we

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

Hi
I'd suggest taking a look at the following link to get started with
macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

For allowing the macro to insert text in a specific cell this cell is
either unprotected or the macro will disable the protection at the
beginning (and reapplie it again after finishing the insertion).



--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank,

Thanks for the sample codes.....but as informed, I am totally new
with
VBA. So, please advise me if it is wrong, I will copy the sample
codes
and insert (as additional line) in the macro I recorded, correct?

How about the pop up box to fill in the name? Any code for that? I
tried to protect the cell and use macro to insert a word there but
was
prompted with error for the cell is protected. How can we enable the
macro to insert something into the protected cells without
unprotecting the whole worksheet? Can we?


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