View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sgwapt Sgwapt is offline
external usenet poster
 
Posts: 15
Default User Access to System

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