Obtaining Windows credentials from VBA

[hicksi]

Suppose I have, on my single visible sheet, a button.
When the user clicks the button, it prompts for a username/password (default username is currently-logged-in)

Is it possible to use Windows authentication to verify that the entered username/password are correct WITHOUT STORING ANYTHING? If so, how?

Is it possible to check the user's Windows Groups and (if they're a member of group XXX) make a number of other sheets visible?

 

[gruntingmonkey]

Yes this is possible!

https://pifflelab.com/2012/07/08/excel-hiding-sheets-based-on-username/

The link gives the initial bit of info you are after. Let me know if you have any specific questions after.

I will just remind you that if a user does not enable macros when the sheet is opened... all security goes kaput.