Retain VBA Protection While Moving Sheet to New Workbook

Hello,

I have a sheet with VBA code that is protected. The file is used as a final dimensional report, so the form is often opened and the sheet is moved to an existing file of other dimensional reports. When the sheet is moved, the project viewing protection does not go with it since it is now part of a new workbook. Is it possible to lock the vba of just a sheet for viewing so it stays protected even if it is moved? Thanks!