Deleting cell data upon open based on cell value

[Darren_workforce]

Hello,

I have 12 tabs (Jan, Feb, Mar, Apr...) and anytime the file is opened, I would like to have specific cell values deleted using VBA. I have the code below which works for the range but how should it be adjusted to find and delete specific cell data? In all, I would like all ones, zeroes, bereavement and training removed upon opening the file.

Private Sub Workbook_Open()
    Application.EnableEvents = False
        Worksheets("test").Range("A1:A11").Value = ""
    Application.EnableEvents = True
End Sub

Thank you in advance for assistance!!

 

[Darren_workforce]

Sorry I forgot to add previously: the worksheet is a shared data connection with another file so anytime the refresh is performed, the removed cell data CANNOT return.

 

[Darren_workforce]

Sorry I forgot to add previously: the worksheet is a shared data connection with another file so anytime the refresh is performed, the removed cell data CANNOT return.

I believe I have the macro for the clear contents when the file opens. However, since it is a data connection and set to refresh periodically, it pulls the data up after the refresh and does not continually clear the requested contents. Is there a workaround for the refresh?