password on excell sheet

Hi there, I'm looking for advice on the best way to go about constructing a module to get my desired result. I have a commissions file that i want managers to be able to go in and review the commissions. Each manager will have a username and password. Each manager will require access to...

Hello, I'm trying to use a toggle button to protect and unprotect a worksheet. I have this code Private Sub ToggleButton1_Click() If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect "test" Else ActiveSheet.Protect "test" End If End Sub Although, It works (in a sense that...

I am trying to find a way to restrict which sheets a user can view by using a username and password. I am testing it first on a simple workbook called TEST with only 3 sheets and 2 users but eventually it will be used on a workbook with approx. 20 sheets and about 8 users and an administrator...

I'm really hoping someone can help me with this code! I've searched this forum and found some older posts about it but I still I can't get my coding to work!! There will be seven people using this workbook and they're each assigned their own tab to work with. I've got cells locked and each...

I protect my excell sheet by assigning a password but forget when later i come up to use that excell sheet in Ms office 2010.