Hey guys, I have the following code snippet in excel's On Open.
When the code runs, evrything up to this point works fine. When I execute the code in vba, the data validation populates correctly and everything works fine. However, when I save and reopen excel, the file errors out and gives me this message:
Excel found unreadbale content in 'Filename' Do you want to recover th ecntents of this workbook?
I say yes, the file opens, and the validaiton is gone. Have I used the wrong syntax or something?
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True