Hello.
What I want to do is Open a Macroed Template Workbook (via Macro) from
another workbook.

The Template Workbook has ActiveSheet Protection & other macros which need
to be disabled prior to copying & pasting from My Workbook.

At the moment what I have been doing is Enabling the Macros on Open, then
running an ActiveSheet Unprotect macro, closing the file, then re-opening it
with Macros disabled, then copying & pasting a range from My Workbook.

I then use Save As and rename the New (Template) File.

My aim is to develop the files (& their automation), then pass both onto
another user, so ideally I want to bypass the Enable, Disable Close Re-open
portion before I do this.

Any ideas?