| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
| Comparing password entry vs stored password - 2003 | Excel Programming | |||
| VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming | |||
Linear Mode
