Not sure this is what you are looking for... but I have a module that will
run at a certain point in runtime that uses ADO to write the user and other
information to an Access database on a network server. Seems to work well.

"Sgwapt" wrote:

Hello,
What would be the best approach to listing users and their access codes in a
data system made in Excel. It would be nice to have this were the average
user cannot see the list when system is in run-time.

At this point I am only able to make the list on a worksheet and use VBA to
hide rows & cols when file is opened.

Have not played with Class Mods yet so not sure if that would work. Have
used select case statements and maybe that is the best method but could get
complicated if user list grows large.

Your help is apprepriacted
Thanks
--
George G