Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock individual modules
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock individual modules
I believe it's all or nothing. Lock the entire project or not.
Barb Reinhardt "Evan Weiner" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock individual modules
Can you place the modules that you wish to lock in a separate addin or
file? Paul --------------------------------------------------------------- On Mon, 20 Oct 2008 15:17:06 -0700, Evan Weiner wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock individual modules
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. -- Thanks, Shane Devenshire "Evan Weiner" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i lock individual cells within a worksheet? | Excel Discussion (Misc queries) | |||
how do i lock individual cells within a worksheet? | Excel Discussion (Misc queries) | |||
How Do i Lock individual cells? | Excel Worksheet Functions | |||
You should be able to lock individual Excel cells | Excel Worksheet Functions | |||
Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) |