Thanks so much Paul and Graham. I ended up using a combination of the modeless userform and making the TakeFocusOnClick property of the form call button to False which has solved my query.
Thanks again for all your valuable feedback and direction; much appreciated.