You need to look at where you wrote the vba.
Is it in a module?
In what workbook?

See... if you begin by recording a macro, the "default" is to put the
macro in a module in the file  "Personal.xls". This is only available to you.
You should be able to see this in VBA's object browser.
then, when you created the form.. did you use a userform? or is it
actually just data  on a spreadsheet?
If it was a userform, then you should be able to look at the Objec browser
and tell where it's stored.

I stongly suspect that you've created your vba  in your personal workbook
All you need to do is create a module in your other workbook  and copy the
macro to this module.