Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PROTECT MACRO IN NEW WORKBOOK
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PROTECT MACRO IN NEW WORKBOOK
As a practical matter I don't think you can do what you want. The only
suggestion I have is to keep the absolute minimum code possible in each sheet module, moving the other code into a standard module. Of course when a sheet is copied to a new workbook the sheet code will no longer work so this suggestion is viable only if that's okay. -- Jim "K" wrote in message ... | 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Protect the Whole Workbook and Allow Range Edits | Excel Discussion (Misc queries) | |||
Macro to protect and unprotect all sheets of the current workbook | Excel Programming | |||
Use Macro to protect choosen sheets in workbook | Excel Discussion (Misc queries) | |||
Password protect a workbook created and emailed by a macro? | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming |