VBA Code to Protect Cells

[ALS218]

I'm a fairly strong power user of Excel, however, to my dismay, I never learned VBA which I'm not limping along trying to teach myself as I go. That said, I'm able to record macros and make very lite modifications often times which still takes a bit of research for me to get right. At the moment, I have a recorded Macro where I copy all the tabs in my workbook to a new instance of excel and the data is hard pasted to the new instance while maintaining a locked/protected status of my source template file when the macro completes running.

What I'd like to be able to do is inject some VBA code that will protect my header which is range C2:Z3 and logo (which is an inserted image) within this range in the output data file which is a new instance of excel. Is this even possible?

Any help would be much appreciated!

 

[Micron]

Could you not achieve this by pasting into A4 on down/across (or C4 as the case may be)? Impossible to be specific without more info. Posting the code you have is usually a good start. If you do that, use code tags ("VBA" button on posting toolbar) to maintain indentation and readability.