Code to create a new workbook that also includes code

Originally Posted by Norie

Couldn't you use a template workbook with the code already in it?

This is probably what I'll end up doing if I can't do what I originally wanted. The first workbook is going to be distributed though and it seems a bit messy to have to distribute two.

Originally Posted by Norie

Perhaps a template worksheet, with the button and code, in the distributed workbook then?

Ok, better, warmer, liking the sound of that. I guess I could hide that worksheet from view in the original workbook. The code then, if I put that in the sheet object instead of as a module where I'd normally put it, would it just go with the sheet when it's copied? Is that right? The code will only perform a copy of data to an already existing workbook so is it not important to have that in a module? Self taught with VBA but still don't fully understand why a code would need to reside in an object, a module or a class module.

Ok Norie, I'm gonna give that a go and see how successful it is.

Originally Posted by Norie

...it is possible to create code using code but that would require changed in the users security settings.

Since my OP I've found references to something called VBIDE. Is this what you are talking about? The users security settings should already be ok as they've all been set up to "Enable all macros" and "Trust access to the VBA project object model" in The Trust Center already.

Thanks very much for your help Norie!