Protect macro

[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

 

[Dave Peterson]

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.