VBA that copies module and code into a new workbook

[Jstns]

HI Guys!

I'm running into some problems with this macro I found online. I think I adjusted everything to suit my needs, which is to copy module2 with the macro's it contains into a new workbook. Somehow this code is not doing anything though. No code is transferred to the example file.

Hope you can help out!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[BellyGas]

if you step through the code, what happens when you execute the line

Please Login or Register  to view this content.

with the on 'error resume next' commented out?

[Jstns]

It says "Programmatic access to visual basic project is not trusted!

[Kyle123]

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

[Jstns]

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

Is there another way how to achieve the same result? I would like to copy my macro in a New workbook

[BellyGas]

A possible workaround would be to have the new workbook already set up with your code present and just copy data to it rather than a VBA module.

[Kyle123]

It's a bit hard to comment without more context, however a workbook template might be more appropriate, possibly and addin, or put the code in the sheet so that when the sheet is copied, it takes the VBA with it