signature line

  • Thread starter Thread starter pdaws
  • Start date Start date
P

pdaws

I have created a form in Excel 2002 that requires three different signatures.
I would like for each signature's username to appear in the specific cell
that they should sign when they review the form. Is there any way to create
such a code?
 
Private Sub Workbook_Open()
Dim uname As String
Sheets("Sheet1").Select
uname = Environ("UserName")
Select Case uname
Case Is = "Gord"
Range("A1").Value = uname
Case Is = "Ralph"
Range("A2").Value = uname
Case Is = "Agnes"
Range("A3").Value = uname
End Select
End Sub


Gord Dibben MS Excel MVP
 
It has to be copied into Thisworkbook module.

Right-click the Excel Icon left of "File" on the worksheet menu bar.

Select "View Code".

Paste into that module.

But................having it in a regular module should not produce an
error, just not run.

What is the error message and number?


Gord
 
Back
Top