Using a macro to create a macro

[merry_fay]

Hiya,

I have a master spreadsheet which uses a loop macro to create lots workbooks
from it to send out.
I need to protect these sent out workbooks but also enable opening & closing
grouping. I've got the code to protect & allow this, but need to make it an
auto-open macro.
I don't want the auto open macro on the master as I have to keep going in &
playing with this, but I do want it on the spreadsheets created from it. How
can I get the macro which creates the sub-workbooks to also create a macro in
them for auto-open?

Thanks
merry_fay

 

[Bob Phillips]

Create a template workbook with the code in, and use this when creating new
workbooks.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)