Problem Hiding VBA

[bglaugh]

I'm creating an answer sheet for a quiz I've designed for some of my students. I've used VBA to make a picture appear when all the correct answers have been entered and it all works well.

However, not to be too mean to 15 year olds, many of my students can be devious little feckers, and I want to hide and password protect the VBA code so that they can't just change the pictures visible section to true. I can password protect the workbook and worksheet, but not the VBA.

I'm entering the Visual Basic editor and I can see my simple script. I then click Tools - VBproject properties - protection. I'm clicking the "Lock Project for Viewing" box then filling in the password and confirming the password and clicking OK. But I can still see and edit my script, despite protecting the sheet and workbook.

What am I missing?

Thank for any help you can give.

[Andy Pope]

The lock will not take affect until you re open the workbook.

[Leith Ross]

Hello bglaugh,

Welcome to the Forum!

The protection won't take effect until you close and reopen the workbook. You will then need the password to view the VBA project code.

Sincerely,
Leith Ross

[bglaugh]

Awesome.

Thanks for that. I feel slightly less stupid now.