PDA

View Full Version : Integrate Excel with AD.



nirvana_1
03-24-2009, 01:05 PM
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.