Using a macro to create a macro
 

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 :-)

Using a macro to create a macro
 

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)

"merry_fay" wrote in message
...
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 :-)