Moving vba code from one workbook to another (using vba)

[AidanKing]

Hi,
I have created a workbook with some code running on each sheet. The code allows a user to select multiple items from a drop down list (rather than only one as allowed by "Data Validation" too)l. If I select some of the data on one of the sheets (for one user for example) and move it to a new workbook is there any way to move the code at the same time so the new user can continue using the code but on this new workbook?
thanks in advance.

 

[Kenneth Hobson]

My guess, without seeing your code, is no for simple copy paste. Doing it in a macro would depend on your code. Likely, a VBAComponents method would be needed.

A copy of the worksheet to a new or existing workbook "might" work. Again, it depends on your code.

 

[AidanKing]

thanks Kenneth, A move/copy of the worksheet to a new workbook does work, I might have to go down that route and remove any unneeded data from there rather than before the move, just have to manage that in vb now. thanks for your help.