I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we need
to authenticate that it was that person. Is there any way to do this?
Thanks!

Get the login id and put it in yourself, they get no option

Range("A1").Value = Environ("UserName")
Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we
need
to authenticate that it was that person. Is there any way to do this?
Thanks!

I am new to macros, how exactly does this work? Thank you!

"Bob Phillips" wrote:

Get the login id and put it in yourself, they get no option

Range("A1").Value = Environ("UserName")
Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we
need
to authenticate that it was that person. Is there any way to do this?
Thanks!

Hi Jasmine,

What event would trigger the signing, a change in (a certain) cell(s),
closing the workbook, or what?

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am new to macros, how exactly does this work? Thank you!

"Bob Phillips" wrote:

Get the login id and put it in yourself, they get no option

Range("A1").Value = Environ("UserName")
Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we
need
to authenticate that it was that person. Is there any way to do this?
Thanks!

That works perfectly. I put a button on the page and assigned it to that.
Thank you so much for your help!!!

"Bob Phillips" wrote:

Hi Jasmine,

What event would trigger the signing, a change in (a certain) cell(s),
closing the workbook, or what?

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am new to macros, how exactly does this work? Thank you!

"Bob Phillips" wrote:

Get the login id and put it in yourself, they get no option

Range("A1").Value = Environ("UserName")
Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we
need
to authenticate that it was that person. Is there any way to do this?
Thanks!

Hi Jasmine,

I was suggesting an automatic way of signing, not needing your user to do
anything.

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
That works perfectly. I put a button on the page and assigned it to that.
Thank you so much for your help!!!

"Bob Phillips" wrote:

Hi Jasmine,

What event would trigger the signing, a change in (a certain) cell(s),
closing the workbook, or what?

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am new to macros, how exactly does this work? Thank you!

"Bob Phillips" wrote:

Get the login id and put it in yourself, they get no option

Range("A1").Value = Environ("UserName")
Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"Jasmine" wrote in message
...
I am trying to figure out a way to let users "sign" an spreadsheet
for
approval. We could accept them typing there initials in a cell,
but we
need
to authenticate that it was that person. Is there any way to do
this?
Thanks!