Require User Login

[Rick_Stanich]

I worked out most my problems, now Im trying to work out this Excel problem :D
I have a login macro, where I have setup User initials on sheet7 and using a prompt the user enters there intials.
From here I want to prevent the use of the workbook (Hiding buttons, I already have that working) for non-approved users.

Please Login or Register  to view this content.

Attached file has internal macros.

Any hints, tips or examples are appreciated.

[Mordred]

Not really sure by your post what you want done? Everything seems alright in your workbook. As for non-approved users, maybe you should try hiding all sheets except fo rthe Main Page sheet and if the user initials match up, unhide appropriate sheets, else keep them hidden.

[Rick_Stanich]

All the sheets are normally hidden, they are viewable for this query.
The current code doesnt work, I can type anything at it allows the buttons to be enable on my form.

[Andy Pope]

Here is one way.

Please Login or Register  to view this content.

It uses the MATCH function to check whether the initials are in column G.
There is also a prompt incase the user wants to escape the process of trying intials entry.

[Rick_Stanich]

Thank you Andy!
Im going to have to study this one, I understand some of it.