View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default AUTHORITY OF VARYING RIGHTS

Could anyone assist me with a macro in the following situation:

1. A pop-up dialogue box appearing asking for login & password;
2. There are 3 persons allowed to login;
3. When Mr. A logs in he would be allowed to access only as read-only;
4. When Mr. B logs in he would not be allowed to view only column B i.e.
column would be hidden; and
5. When Mr. C logs in he would be allowed complete access;

Appropriate macros would be appreciated.

Thanx in advance.