Chabu,

Thanks, I'll look at that possibility. The critical point to any solution is that it run on XL 2004 on our Macs.

Mik,

Thanks, that may be what I need; the variable would be a fixed value for each user. At the moment, I'm leaning towards your earlier suggestion of using the button_click event.

Thanks,