Copy Sheet and Macro without linking to old sheet

[Simon-ch]

Hi,

With a macro I copy a sheet out of the workbook and create a new one.
I then want this new sheet to have the following macro:

Please Login or Register  to view this content.

Until now I have a userform that gets copied as well.
But it will then refer to and also attach the old workbook, how can I change that ? Since the new workbook has a naming policy (date, name etc) it's never the same and cannot be used directly.

[Simon-ch]

Ok, I solved the problem by using a cmdbutton instead of a userform.
But my problem now is that the outlook object library in the generated version isn't enabled, why doesn't it copy these settings, because the source workbook has it enabled ?