Share via

Data Validation error when opening an Excel file

Anonymous
2015-04-13T19:38:18+00:00

Does anyone know why I would be getting an error with a new workbook I created via VBA when i try to reopen the file?  It does not have validation and no special formatting.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2015-04-14T03:18:14+00:00

    I was able to figure out how to accomplish this by using.  Thank you for the response.

    Cells.Select

        With Selection.Validation

            .Delete

            .Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator _

            :=xlBetween

            .IgnoreBlank = True

            .InCellDropdown = True

            .ShowInput = True

            .ShowError = True

        End With

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-04-13T20:27:58+00:00

    Post the code which created the new workbook.

    Gord

    0 comments