Protect macro code from viewing/editing

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
 
M

Mario

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


kind regards from AUSTRIA (graz)

mario
 
C

Chip Pearson

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 [email protected]
 
K

Keith

I had tried that before and can still go right to the
code from the EXCEL workbook.

Any other thoughts

Keith
 
Top