How to get Active Directory Usergroup information

[Bert v.d. Brink]

For a worksheet I developed, for use by different types of users, I
need 2 levels of authorisation for using this sheet. I'm think of
using Active Directory Usergroup information to identify the type of
user that is using the worksheet.

So
A. Is there a way to identify the Active Directory Usergroups of user
that has open the worksheet?
Or
B. Is there another way to implement authorisation?

Bert van den Brink

 

[Jake Marx]

Hi Bert,

Something like this should work:

http://www.myitforum.com/articles/11/view.asp?id=3259

This example is VBScript, so you'll want to declare the variables
explicitly. But it should do what you are looking for.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]