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!

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

How do I protect a VBA Project in Excel?

Protection

How do I protect a VBA Project in Excel?

by  LoNeRaVeR  Posted    (Edited  )
1) [color green]Open[/color] Excel
2) [color green]Open[/color] the file that contains the VBA Project to protect
3) [color green]Press[/color] [color red]ALT+F11[/color] to open the Visual Basic Editor
4) [color green]Press[/color] [color red]Ctrl+R[/color] if the Project Explorer isn't displayed
5) [color green]Right-Click[/color] on the any item in project to protect
6) [color green]Select[/color] the [color gray]VBA Properties...[/color] menu item
7) [color green]Select[/color] the [color gray]Protection[/color] tab
8) [color green]Click[/color] the [color gray]Lock project for viewing[/color] checkbox
9) [color green]Enter[/color] your password
10) [color green]Confirm[/color] your password by entering it again
11) [color green]Click[/color] the [color gray]OK[/color] button
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top