![]() How To Copy Worksheets Without Embedded Code What if you didn’t need to worry about others modifying or even stealing your code? With the Unviewable+ VBA project, this thought is now a reality! Place the bulk of any such code in a standard module and call on it from the worksheet. Include only minimal code in the worksheets.Review > Protect Workbook > to prevent worksheet copying. The workaround for this problem involves 2 steps:įile > Info > Protect Workbook > Protect Workbook Structure or Thus, the code embedded in the newly copied worksheet will be visible, even if the source VBA project was password locked or custom protected as unviewable or Unviewable+! Unfortunately, the properties of the source VBA project, including its password, cannot be transferred to the target workbook. The new workbook has its own VBA project, which is unlocked at the time of creation. Copy the worksheet with the event code to a new workbook.Lock the VBA project with a password (VBE > Tools > VBAProject Properties > Protection).This hack can be demonstrated with the following simple steps: ![]() VBA code stored in worksheets (document modules) can be read from workbooks with unprotected structure (Review > Protect Workbook), even if the VBA project is password locked or unviewable. Security Tip: Learn How To Protect Your Code
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |