Hi gillianjack, welcome to the forum.

Did you intend to post some VBA?

Is this going to be a rule or automatic running of VBA?