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

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]


Bert v.d. Brink wrote:
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