Actually, maybe VBA might be an answer if anyone can advise how to code it (please)
Initial aversion is because I using prewritten templates by a supplier and I'm not sure if new VBA will 'break' their code
Didn't understand the building block comment
PS, the document is locked from user editing, hence they wouldn't be able to modify using drop downs (or anything) when they open the document
|