Integrate Excel with Active Directory.

[nirvana_1]

Is there any vba module i can use to integrate Excel with Active directory.

Here is my requirement.
a) When user opens the excel workbook, they should be prompted to login with their AD account details. Username and password screen.
b) Once they login they should be able to see the contents of the spreadsheet.
c) if their logins are not successful then the contents of the speadsheet should be either hidden or blank.
d) The integration should only work when enable macros option is selected when the workbook is open. Otherwise it should be blank or hidden.
e) i want to control access to the workbook based on AD logins. Only allowed users should have access to the spreadsheet.

Thanks.

[stanl]

You could use LDAP, depending upon how the OU's are set up. If you are thinking about setting up a shareable/updateable workbook IMHO you are in for a heap of headaches.:banghead:

You might consider an Excel_User OU and restrict the folder that contains the workbook to that OU, then use LDAP in a separate module to update the OU. Just .02 Stan