Checking Macro if fields are emply to not prompt - problem 1

[YNOTU]

hello all, I have this code but can't find what line is not working.

Private Sub Workbook_Open()
If [C1].Value <> "" And [C2].Value <> "" And [K2].Value <> "" And [C4].Value <> "" And [J6].Value <> "" And [H7].Value <> "" Then Exit Sub
Dim Client As String, Project As String, Job As String, ClientID As String, AccountManager As String, DataTechnician As String, ProductSize As String
Client = Application.InputBox(Prompt, "Client Name :")
Project = Application.InputBox(Prompt, "Project :")
Job = Application.InputBox(Prompt, "Job Number :")
ClientID = Application.InputBox(Promt, "Client ID :")
AccountManager = Application.InputBox(Prompt, "Account Manager :")
DataTechnician = Application.InputBox(Prompt, "Data Technician :")
ProductSize = Application.InputBox(Prompt, "Product Size :")

Range("C1").Value = Client
Range("C2").Value = Project
Range("K2").Value = Job
Range("K3").Value = ClientID
Range("C4").Value = AccountManager
Range("J4").Value = DataTechnician
Range("H7").Value = ProductSize


End Sub

One this worksheet is filled by the user and opened again, it should not prompt you to input but this sheet does no matter what is typed then saved.

Why don't I see it??

Thanks

 

[PHV]

You test J6 but don't fill it if empty.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[YNOTU]

Thank you PHV