The sample doc you posted had the macro running on exit from each of these fields. That means that as the user moves the cursor away from that field, the macro fires and sets the colours for all those fields. There is no event trigger to make the macro fire when they change the choice and before they leave the field.

The user doesn't manually run the macro, it happens automatically as they leave the field. It all relies on the users enabling macros though. If they don't do that then nothing happens.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Ok, everything clear now - I set the formfiled in the document to run the macro on the exit and it works perfectly. Good thing you mentioned that it won't work if others won't enable macros. It didn't occur to me
(The funny thing though, when I pick an option the document automatically scrolls down a little. Do I have some weird settings on or something?)

Thank you one last time and wish you all the best!