Protect macro code from viewing/editing

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

In older versions of EXCEL I was able to password protect
my VBA code so that users couldn't access to
read/copy/edit. I can not find a way to do this in EXCEL
2002.

Any help would be appreciated.

k
 
hi keith
very easy
go to EXTRAS - Properties of VBA project - protection


kind regards from AUSTRIA (graz)

mario
 
Keith,

In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. There, check the "Lock project for viewing" option and
give it a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I had tried that before and can still go right to the
code from the EXCEL workbook.

Any other thoughts

Keith
 
Back
Top