how do i use excel macro (form) in other sheets?

Hi,

I want to write a macro (using forms) to do some data checking. The form will prompt the user to enter various inputs and will perform some actions depending on the input. I have already developed this macro for an excel file. The problem is that I want to use this macro again on a different file. I have made it generic. However, I don't know how to copy it across to the other file. Do i have to copy the whole code and export the form? Just copying across the code is easy but i would not want to export and import forms. Plus, I want others in my team to use the same macro on their files. How do I accomplish this?

Thanks in advance.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.