PDA

View Full Version : How to protect VBA if read-only?



Surii
09-12-2012, 07:56 PM
Hi all

I want to protect my VBA code when the file is opened as read-only, such that the users will not even be able to click on the developer-visual basic or press Alt F11. In a word, the whole VBA will be locked, even they have their own files opened that have macro codes, they will need to close my file in order to be able to go back into visual basic editor.

Any clue? :confused:

:help

Thanks in advance!

Tinbendr
09-13-2012, 06:26 AM
The most suggested solution is to create an add-in.

Surii
09-13-2012, 07:43 AM
Hi David

Not possible to just code it in vba? It's just for read-only users.