the other PCs have Macros enabled.



The Userform is in Project - Normal when you open the VBA editor

Normal is your personal normal.dot template. You need these to be in the project for the template you are distributing.

In the vba Editor you can right click on your form and export it to your desktop. Then right-click on the project for your distribution template and import it in. Create a module for your macros and copy and paste any macros not in your userform needed for the userform into your new module.

Once you know your Userform is working, you can delete these from your normal.dot.

works a treat. Thanks once again, you are a legend