![workbook has lost its vba project excel 2007 workbook has lost its vba project excel 2007](https://media.slipstick.com/images/2011/07/vb-editor.png)
Place the bulk of any such code in a standard module and call on it from the worksheet.
![workbook has lost its vba project excel 2007 workbook has lost its vba project excel 2007](https://cdn.educba.com/academy/wp-content/uploads/2020/07/VBA-Project-Password-Example-2-4.png)
![workbook has lost its vba project excel 2007 workbook has lost its vba project excel 2007](https://blog.sandro-pereira.com/wp-content/uploads/2010/09/excel-addfeactures-25b25d7a526258.jpg)
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. If you declare a variable using the Public declaration in a standard code module, that variable and its value is available to any procedure in any module of the project. The current methods to password protect your code are either very weak and can easily be. Excel supports 'global' variables only at the workbook level. The Unviewable plus project is an attempt to once and for all protect your intellectual VBA property without external file dependencies from the lion's share of hacking tricks. The new workbook has its own VBA project, which is unlocked at the time of creation. Unviewable+ VBA Project For Excel PowerPoint Word. Copy the worksheet with the event code to a new workbook.Lock the VBA project with a password (VBE > Tools > VBAProject Properties > Protection).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. This hack can be demonstrated with the following simple steps: