move data system to an Access .mdb backend
add table of users

OR

use an add-in - but this depends on your usage & deployment

"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