AUTHORITY OF VARYING RIGHTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Faraz,

Trying to acomplish this in Excel would be quite dificult as most of the
secutity features offered can be easilly bi-passed by anyone who looks around
hard enough on the net.

You should start altering the secutity settings of the workbook based on the
result of a login but, as I said, these can be amended in a matter of seconds.


HTH

Simon
 
Thanx Simon,

But as u said it could be bi-passed most of the users here hardly have an
idea of bipassing or even using correct formulae.

However, if u can't provide a macro I would highly oblige even if there is
any other way for the same if not in excel?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Varying Number of Rows 0
Sorting 5 columns of data based on column A 6
Karma for O'Leary 3
Access Employee testing checklist 0
Keeping track of users LogIn 5
Counting defined values 4
Sum Exported data automatically from Access database 9
Populate one column based on the dropdown choice of others 2

Back
Top