Thanks a lot. A textbox asking for a password is a workable solution.

Frederick Chow
"JE McGimpsey" wrote in message
...
The simple way would be to require a password to run the macro:

Public Sub MyMacro()
Const sPWORD As String = "drowssap"
Dim vResponse As Variant
Do
vResponse = Application.InputBox("Password: ", Type:=2)
If vResponse = False Then Exit Sub 'User Cancelled
Loop Until vResponse = sPWORD
'your code here
End Sub

Then protecting your code (Tools/Project Properties in the VBE).

However, that will not keep anyone with the gumption to find these
newsgroups from finding a way to see/run your macros:

http://www.mcgimpsey.com/excel/fileandvbapwords.html

A more secure way is to put your code in a separate add-in so that it's
never sent to the others.



In article ,
"Frederick Chow" wrote:

Hi all,

Very often I have to send my Excel files (with macros) to others. Is
there
any simple way of preventing third parties from running the macros in
those
files? Thanks.