Hello xld,


Hello xld,

Thank you, I appreciate your reply.

To test your suggestions I created a new document and added the code in the appropriate places, but for some reason whenever I click on either of the two buttons on the tab I get the following message:

The macro cannot be found or has been disabled because of your Macro security settings.

I have even saved the new document to the templates folder on my C drive and the error still occurs, do you know why this is happening ???

______________________________________________________________________

Hello Paul,

Thank you, thank you,

Your suggestions run perfectly.
I will have to look closely at both suggestions to learn from what each of you has done.

I really appreciate both of you offering me help.

Regards,
Dave T