Lock individual modules

  • Thread starter Thread starter Evan Weiner
  • Start date Start date
E

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?
 
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.
 
Back
Top