password

[nureen]

Hi Guy - wondering if you knew the answer to this one??

I have got made a spreadsheet - which i only want certain users to get access to. I have created a button on another page (entry page) and would idealy like for the button to bring up a text box in which the user can only type the password inorder to enter it?? i dont not want to password protect the entire workbook - just that one sheet - because users need to get infromation from other sheets in that workbook.
Thank you!! x

 

[MorganO]

This is relatively easy to do.

You can use the Visible property in VBA to hide the sheet from view:

Sub HidetheSheet()

Sheets("Sheet2").Visible = xlVeryHidden

End Sub

You can then attach code to your button to unhide the sheet:

Sub ButtonOne()

SheetPassword = InputBox("Enter the Password")

If SheetPassword = "123ABC" Then Sheets("Sheet2").Visible = True

End Sub

You would just have to remember to hide the sheet again when the user is done viewing/using it.

Hope this helps.

Owen

 

[Datsmart]

This post from last December has suggestions and code to limit user access by their Username from the environment.
http://www.mrexcel.com/board2/viewtopic.php?p=1198464
You should be able to adjust that code with Owen's suggestion to setup what you want.