How can I hide the code??
Can anyone tell me how to hide VBA code in a excel
applicatiuon so that users can't see it or modify it. |
How can I hide the 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 ToolsVBA project properties See the protection tab This way they can't see or edit your code -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "SanMartin" wrote in message ... Can anyone tell me how to hide VBA code in a excel applicatiuon so that users can't see it or modify it. |
All times are GMT +1. The time now is 09:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com