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