Protecting a VBA project
Ekta,
If you select the project properties, you will see there is a Protection
tab. Here you can lock a project for viewing and set a password.
Not foolproof, but will stop the casual viewer.
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"Ekta Singh" wrote in message
...
Hello,
I have written a VBA program i.e a macro for an Excel
sheet.Could anyone please let me know how can I disable
the end user from viewing the code in this macro.When I
give my Excel sheet to the end user,he should only be able
to interact with the worksheet and the macro should
perform the calculations but its code should not be
accessible to the user.Any help would be highly
appreciated.
Thanks,
Ekta.
|