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

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

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

Usage and deployment is not that large.
Right now there are 9 users that have access to the system.
Some can enter data and other can create reports.

There is one admin that can gain access to the entire system.
All others can only perform via userforms and command buttons.
If they use the X on any form it hides all sheets expect for one, a welcome
sheet where they can either exit or restart without having to close & reopen.

This is used on a network server so is there a way to have them use their
logon and password on the nework to compare to?

Thanks

--
George G


"Vacation's Over" wrote:

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