I want to stop a macros based on people not filling in the information

[watermark123]

I have created a macro to move the information from one sheet to another sheet i.e. Range("e4:AI4").Copy Sheets("Completed List").Range("A1048576").End(xlUp).Offset(1, 0)

I now what to not allow the users to use this macro unless all the information is filled in – is this possible and if so how? I have tried to copy a few ways from post on here but nothing works

[ranman256]

Now this code is based on FORM entry, but you can adjust it if the user is entering on a sheet.

I do my checks via code (not in the field property)
All in 1 place, easier to change...say a SAVE_click event...

usage:
if IsValidForm() then SaveData

Private Function IsValidForm() As Boolean
Dim vMsg
Select Case True
   Case IsNull(dtpWeekOf)
      vMsg = "Date field missing"
   Case IsNull(cboUser)
      vMsg = "User name is missing"
   Case IsNull(txtEmail)
      vMsg = "Email field is missing"
End Select
If vMsg <> "" Then MsgBox vMsg, vbCritical, "Required Field"
IsValidForm = vMsg = ""
End Function