Hiding/Protecting Specific Code in VBAProject

[prestonosivad]

Hey team -- Long time fan of Mr. Excel, but this is my first post and I hope that you can help me out!

The code written helps me to determine if my students are sharing excel templates in order to submit less-than-honorably-produced assignments.

I created some code to automatically log the usernames of those that open and edit the workbook on a "xlVeryHidden" sheet named "Log". I have written the code directly in the VBAProject (filename.xlsm)>Microsoft Excel Objects>ThisWorkbook

**THE QUESTION: Is there a way to specifically hide/password protect JUST this code (or JUST the "ThisWorkbook" object)? My class involves VBA projects, and requires the students to be able to create new modules.

 

[Jaafar Tribak]

Hi and welcome to the board .

Unfortunately, you can't protect part of a vbproject

Have you considered placing the code in the Personal workbook or in an addin which you can protect seperately ? (this would work if the workbook is always opened from the same pc where the Excel application is installed)

Another workaround is to have an intermediary workbook that would open the target workbook , update the log sheet and close itself