i have an idea, and I'm sure i'm not the first to Invision something like this.. but i have a lot of questions in regards to it..
IDEA:
I would like to have an add-in.. that can be distributed to users (a select group), that will give users access to things.. userforms, functions, etc. These would all be accessible from a custom menu
First I would like to have some sort of user level access system built in..
so a user would install the add-in.. and the add-in would check a datasource (Access table, text file, whatever) and check if the username exists (obtained from ENVIRON("UserName"). If it does exist then it grabs the level and sets that level setting to the registry (or something like that) If needed.
Based on the users level (I think something like simple numbers (1, 2, 3, etc for different levels), I would like certain functions to be available to them..
If the username does not exist then add that user to the datasource at the basic level..
QUESTIONS:
how would you create a user authencation system as described, and would it work as described?
can modules be dynamically loaded to an add-in based off criteria such as user level?
Is there an ON LOAD of sorts that would allow an added module or routine to modify the custom menu already available to the user?
would it be possible to update the addin when required (storing the .xla on a network drive is an option for updating , however having the user use the addin from that location is not (network security settings will not allow this)?
I think thats a goos start...
I'll also explain that this is something I would like to see happen however if it never materializes I would not be extremely heartbroken..
I've had some people tell me it's not possible to do with excel and VBA and that it would require outside applications to make it work (native environmental security settings, etc) it was my local IT guy who says it can't be done.. just looking to shove a little "booyah" in his face...
I have learned alot of VBA in the last few months, however my job is more concept than development, and I feel I still to wet behing the ears to get this up and running.
Long post I know.. and there is still more in my head..
Thanks for taking a look..
I look forward to your suggestions as well as possible solutions..