Is there a way to render the code uneditable in excel. I have made my excel application and deployed to to multiple users but I don't want them to to modify the code. The app is locked with a pass. But the user can still access the VB editor and change that code. I am looking for a way to either hide, lock or make the code uneditable. Is that possible? Is so, would anyone know the steps to take?
PS: Thank you to all who have helpped me so far. Your imput has been extremely valuable.
I am looking for a way to either hide, lock or make the code uneditable. Is that possible?
In the Excel VB Editor Select 'VBProject Properties...' Menu 'Tools->VBProject Properties...' Click the Protection Tab on the properties dialog. Check 'lock project for viewing' and set a password. Remember the Password