Using macro to un/protect sheet

hi hi, thx agen for the previous helps =D
i searched this up to see if i could find nething b4 disturbing you nice ppl
lol, but i still dont understand.
i want to make a button, which will allow the user to View the books n not
rewrite. And a button which allows the user to actually add/edit the data,
however this user would need to enter a password. i want both buttons to open
the same workbook, but each with a different authority. I dont know how to
create like a message or box where the user has to enter a password to gain
access in adding new data .
i've been thinkin long and hard but dont know where to start, can anyone
help me out? lol

thanks in advance =)

Bonbon, how about something like this on the sheet so the user would have to
enter a password to edit

Sub PassWord_To_Edit()
'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 Add/Edit Data")
If MyStr1 = MyStr2 Then

'put your code here to add data

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 2002 & 2003

"Bonbon" <[email protected]> wrote in message
news:[email protected]...
> hi hi, thx agen for the previous helps =D
> i searched this up to see if i could find nething b4 disturbing you nice
ppl
> lol, but i still dont understand.
> i want to make a button, which will allow the user to View the books n not
> rewrite. And a button which allows the user to actually add/edit the data,
> however this user would need to enter a password. i want both buttons to
open
> the same workbook, but each with a different authority. I dont know how to
> create like a message or box where the user has to enter a password to
gain
> access in adding new data .
> i've been thinkin long and hard but dont know where to start, can anyone
> help me out? lol
>
> thanks in advance =)

Thank you Paul B, that worked great!
you said, lock VBA project, how?

thanks again