Password Protected Macro code (VBA) in Excel

[hbui]

I know how to password protect an excel workbook but when you add a MACRO to the workbook...how do you put a password on it?

Thanks in advance.

 

[Macropheliac]

Try this:

Sub Password_Code()
If Not InputBox("Password") = "Your Password Here" Then Exit Sub
'Rest of code Here
End Sub

 

[Smitty]

Welcome to the Board!

In the VBE you can goto Tools-->VBA Project Properties-->Protection-->Lock project from vieving-->Add password (2x).

HTH,

Smitty

 

[hbui]

That works...great thanks so much.