Copying Worksheets with macros

[WLMPilot]

I am setting up a template (worksheet) for someone to copy as needed.
Attached to this template are macros and a userform.

I am setting up this template to use a userform to enter checking account
transactions and each worksheet will be a check register.

My question is this: Do macros and userforms copy along with the worksheet
that is being copied?

Thanks,
Les

 

[Jacques ALARDET]

Hello,

1. If your macro is stocked in the module of the Worksheet : The code is
copied of the same time workshheet
2. If your macro is stocked in other module : You copied the code by
Export-Import
3. If your macro is stocked in Thisworkbook : the export-Import create a
class module
4. If your macro is stocked in Userform : I have not response

But I recommande the stockage of macro in a workbook independant out of the
workbook user : In this cas no besoin to copy the code

 

[Barb Reinhardt]

If you are copying the worksheets with code, you can add some more to copy
the needed worksheet modules as well.

This should get you started.

http://www.cpearson.com/excel/vbe.aspx

Just make sure you have a backup copy of your file before you start.