Moving a sheet module from one workbook to another

I have written a macro to format a spreadsheet and then copy the formatted information into a new spreadsheet and close the original spreadsheet. The problem I have is that I have some code written to highlight a row a certain color based on a data validation list. I need to get that code into the new sheet so that it will work after the macro is closed.
Here is the code I have found/put together to try and move the module. It adds the module as a class module instead of a sheet module.

Please Login or Register  to view this content.

Here is the code I am trying to move:

Please Login or Register  to view this content.

Export it to a .bas rather than .txt