Hi Paul, I've finally finished my automated form with multiple drop down lists that populate an adjacent text box with a value of the selected item, creating a type of shopping list that then gives a final total. The issue I have now is that having saved the form with Editing restrictions of No changes (Read only) but also with Exceptions, all of which work perfectly on my machine but when I send them to a colleague to try out the functionality is lost. The drop down lists work but the text box don't update with a value. I've allowed macros on my colleagues machine but still no joy. Any help would be greatly received. Mark.