Thread: password
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default password

There is no special support for this. You would just show a useform that has
a textbox and a prompt for the password. Then write code to check the
password against some list of passwords you maintain. the code would further
control the level of access. Of course if the macros were disabled, you code
would be easily defeated.

--
Regards,
Tom Ogilvy


"enyaw" wrote:

I need to set up a log on through a user form when i open excel. I need to
have two levels of access. An Administrator level which can do everything
and a user level which can see the sheets and edit them. Can anyone help?