Securing the Macro in Excel Programming.

  • Thread starter Thread starter Neeru
  • Start date Start date
N

Neeru

Hi,

Could comeone tell me how to secure my Macro in Excel
Programming. After i Save the Macro, i dont want the
Users to Edit the code accidentally. Right now If the
Excel file is open anyone can just go to the VB Editor
and can edit the Macro.
I would appreciate any help.
 
Neeru,


From the VBA Editor......
Tools/VBAProject Properties
Protection Tab
Check "Lock Project for viewing"
Enter passwords.

Note: While this will protect your VBA code from the "casual"
user, it's in no way secure. Anyone that has access to this ng
(or the Google archives) can simply ask how to circumvent
that password protection and they'll be given a host of
resources to do so.

John
 
Back
Top