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!
> > > >
> > > >
> > > >
> >
> >
> >
Bookmarks