S SanMartin Oct 30, 2003 #1 Can anyone tell me how to hide VBA code in a excel applicatiuon so that users can't see it or modify it.
Can anyone tell me how to hide VBA code in a excel applicatiuon so that users can't see it or modify it.
R Ron de Bruin Oct 30, 2003 #2 You can place Private before a sub like this Private Sub test() Or add this at the top of the module Option Private Module This way you don't see it in the macro list (Alt-F8) You can Protect your project in the VBA editor Alt-F11 In the menubar Tools>VBA project properties See the protection tab This way they can't see or edit your code
You can place Private before a sub like this Private Sub test() Or add this at the top of the module Option Private Module This way you don't see it in the macro list (Alt-F8) You can Protect your project in the VBA editor Alt-F11 In the menubar Tools>VBA project properties See the protection tab This way they can't see or edit your code
