Protect macro

  • Thread starter Thread starter Paladin046
  • Start date Start date
P

Paladin046

I have a workbook that contains a macro that many people will be
using. can the macro be protected to prevent changes to the macro. I
can protect worksheets but I don't know how to protect a macro.

Garry
 
Open your workbook
Open the VBE
hit ctrl-r to see the project explorer
Select your project in the project explorer window
Tools|VBAProject Properties|Protection Tab
Give it a memorable password (and lock the project from viewing)

But remember, this password, like any password, can be broken by anyone with
enough time or money.
 
Back
Top