Lock individual modules

[Evan Weiner]

Is it possible to lock an individual module in a project without affecting
others?

I don't mind users looking at code, but I don't want them to change certain
modules.

I'm required to lock code, and this seems to lock the entire project. I was
hoping users could provide input with other modules. Makes sense?

 

[Barb Reinhardt]

I believe it's all or nothing. Lock the entire project or not.

Barb Reinhardt

 

[pfsardella]

Can you place the modules that you wish to lock in a separate addin or
file?

Paul

 

[ShaneDevenshire]

Hi,

If you lock the project the user can't see any of the modules without the
password. I suppose you could make the file Read Only, but then the user
would not be able to save any changes they made. You are not going to be
able to let them see the code and also protect it from changes.

If you want to let them see the code you could store a copy of it in a Word
document and then give them a Hyperlink in the spreadsheet to the word
document. In the Excel file you would lock the project in the VBE so they
couldn't make changes.