Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Protection macro form viewing or editing

Status
Not open for further replies.

plutz

Technical User
Oct 4, 2003
21
US
Is there a method to prevent a user from viewing or editing a macro in excel?
 
Hi Plutz

Set the VBA project properties - in the Visual Basic Editor, right-click on the current project, click the Protection tab, check 'Lock project for viewing' and set up a password.

This is common to any VBA project, in Excel or another Office app.

Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top