creating macro to ask for variable info when excel starts

[Flyriverside]

Hello, I don't understand visual basic at all, so don't understand the
help that comes with Excel 2002. We create proposals for different
companies using Excel, but sometimes the guys forget to change the
name of the customer on the proposal. Is there a way I can get the
proposal to ask for the customer's name and enter it in a cell when a
person starts the spreadsheet for the 1st time?

Thanks for any help.

 

[Bob Phillips]

Sub Auto_Open()
Dim sCust

sCust = InputBox("Please supply customer number", _
"Custmomer Proposal", _
Worksheets("Sheet1").Range("A1").Value)
If sCust <> "" Then
Worksheets("Sheet1").Range("A1").Value = sCust
End If

End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)