Signatures

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" <Jasmine@discussions.microsoft.com> wrote in message
news:A02AFD76-ECFF-4857-B944-92A59E676A88@microsoft.com...
> 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" <Jasmine@discussions.microsoft.com> wrote in message
> news:A02AFD76-ECFF-4857-B944-92A59E676A88@microsoft.com...
> > 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" <Jasmine@discussions.microsoft.com> wrote in message
news:CC61C98F-F25A-4E62-89FF-5234ABE81F6C@microsoft.com...
> 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" <Jasmine@discussions.microsoft.com> wrote in message
> > news:A02AFD76-ECFF-4857-B944-92A59E676A88@microsoft.com...
> > > 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" <Jasmine@discussions.microsoft.com> wrote in message
> news:CC61C98F-F25A-4E62-89FF-5234ABE81F6C@microsoft.com...
> > 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" <Jasmine@discussions.microsoft.com> wrote in message
> > > news:A02AFD76-ECFF-4857-B944-92A59E676A88@microsoft.com...
> > > > 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" <Jasmine@discussions.microsoft.com> wrote in message
news:90AD0C98-2E9B-4ABA-830C-457EDB44D2DD@microsoft.com...
> 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" <Jasmine@discussions.microsoft.com> wrote in message
> > news:CC61C98F-F25A-4E62-89FF-5234ABE81F6C@microsoft.com...
> > > 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" <Jasmine@discussions.microsoft.com> wrote in message
> > > > news:A02AFD76-ECFF-4857-B944-92A59E676A88@microsoft.com...
> > > > > 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!
> > > >
> > > >
> > > >
> >
> >
> >