I have data that is linked to various workbooks.
I would like a macro to prevent values being updated where "finalised" appears in Row 5 in various columns.. For eg. where "finalised" appears in B5 , then all then data in Col B must not be updated when opening then workbook,
all the other columns can be updated where finalised in not in row 5
this must be sheet specific as I have several sheets
It would be appreciated if someone could assist me
I would like a macro to prevent values being updated where "finalised" appears in Row 5 in various columns.. For eg. where "finalised" appears in B5 , then all then data in Col B must not be updated when opening then workbook,
all the other columns can be updated where finalised in not in row 5
this must be sheet specific as I have several sheets
It would be appreciated if someone could assist me