Hi,
I am using the following code to copy and save a worksheet from a workbook as a separate workbook. The worksheet that is being saved as a separate workbook contains some VBA, which also gets saved in the process. The problem I have is protecting the VBA code within the copied worksheet as it is transfered to a new workbook. The code is protected within the original workbook.
Is it possible to set the password to protect the code in the new workbook while creating the workbook within the above code? Help!!
Bookmarks