Hi all, I have workbook in which every sheet have macros in Sheet
module and macro is password proted in this workbook. But some time I
have to copy one of the sheets from this workbook to some other
workbook and which I do by right clicking on tab and selecting "Move
or Copy". The problem is that once the sheet is copied to other
workbook then any body can see the macro which is in sheet module by
going into "View Code" as its not possible in original workbook as
macro is protected in that workbook. Beause the macro in new workbook
where the sheet been copied is not protected thats why its easy to
see. Can any firend have code that which "Move or Copy" the current
sheet into other workbook and protect the macro as well in new
workbook so no one can see the macro. I know how to protect macro
manually does any firend have code to do this. any help will be much
appriciated