Password Sign On - Help, please!!

Username is defined as a range. You need it like this

Please Login or Register  to view this content.

Unless you want the .Value in which dim Username as string

Might be more but that is the first one I see. In addition, what would stop someone from disabling macro's or just unhiding the sheet to use as they see fit?

Sorry about that, will do.

Thank you!

I made the change but get the same error. I am going to try as a String next.

The intent is to get the user to login before they answer test questions. I am not too concerned about disabling the macros, but unhiding the sheet is a good point. Ultimately, the user will login, click on a button to get the next item for review, that item will unhide the appropriate questions for their responses to that review type. The first phase works great, but I am adding in 2 more topics for review and will need the excel worksheet to eliminate some of the human error in the more manual process we use today. I am not quite to the hiding rows build yet, but I will definitely like to lock the entire thing down other then their entries once it is complete. I am working on this piece by piece for now.

I appreciate the great input and I'll let you know if changing from a range to a string solves this first problem.

Thank you!

You have two worksheets, right? The first one (which is not named anywhere) and the second one, which is ws3.

I'd suggest that you be very explicit about which worksheet you are trying to reference. You might want to try adding

Please Login or Register  to view this content.

and then precede the ranges that you expect to be on wksSignIn withwksSignIn.Range etc.

Without this human readers (and quite possibly, the Excel VBA environment) could get confused about which worksheet the range is on....

...leading to a possible "method range of object _global failed" error message.

Just a thought,

Tony

Thank you to everyone, went a slightly different direction but it works!
The suggestions were very helpful!

Please Login or Register  to view this content.