password on macros

  • Thread starter Thread starter Guest
  • Start date Start date
Just, some thing like this

Sub PassWord_To_Run()
'must lock VBA project so you can't see the password in it
Dim MyStr1 As String, MyStr2 As String
With ActiveSheet
MyStr2 = ("123") 'This is the password and it is CASE sensitive
MyStr1 = InputBox("Password Is Required To Run this Macro ")
If MyStr1 = MyStr2 Then

'your code here

Else
MsgBox ("Access Denied")
End If
End With
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
In the macro itself, write the code to prompt for the password and to
validate and react to the response.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
Run Macro If Cell have "x" value 0
including macro in protected worksheet 2
Password To Run Macro? 10
Novice - using macro to protect with password 10
Macro to open view with a password 3
not able to enable macro in password protected .xlsm workbook. 2
Excel Excel macro and passwords 3

Back
Top