VBA that copies module and code into a new workbook

You need to enable it in Excel options - note that this is disabled for a reason and not really good practice.

Don't expect other users to be able to run your code