@ Newdoverman,

I went into the vba editor and added a watch for the sheet, I then looked through the sheet properties, particular those in the .protection category and found that there was an item in the .alloweditranges collection.