Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
project | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Need a project. | New Users to Excel |