Enable/Disable Macros

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

Can anyone tell me if there is any way to bypass the
dialog box that requests whether we want to "Enable
Macros" or "Disable Macros", everytime an excel file with
a macro is opened and force the macro to be executed ...

The reason I want this is, Ive written a macro such that
whenever a user opens a file, the macro would ask for a
login Id and a password. If the user enters both these
correctly, he/she would be able to access the data stored
in the file, else the file would close. There is also
another file which contains the list of valid login Ids
and their corresponding passwords from which we validate
the Id and password that the user enters.

Now if the user chooses "Disable Macros", the whole
concept of login ID and password would not work.

Unfortunately the simple idea of protecting the file with
a password is not feasible as the fundamental requirement
is that different users must be able to login using their
own passwords ...

Pls help !!!!
 
Joseph,
Can anyone tell me if there is any way to bypass the
dialog box that requests whether we want to "Enable
Macros" or "Disable Macros",
Click to expand...
There isn't. If there were, what use would there be to
have a dialog box in the first place.

You've already done some work with the login id's and
passwords, so your familiar with writing VBA code.
What you need to do is make the workbook unusable
if macros are disabled. One way to do this would be
to make all sheets except one very hidden when the user saves
the workbook. On that sheet should be a warning that
macros need to be enabled for the workbook to function.

Search Google for "Force Macros" and you'll come up with
a lot of threads and code to do this.

John
 
In a word..... No.

Is there any way you can use standard NT file permissions to restrict
access to the actual file itself?

Another option would be to certify your macros and make sure that all
of the users' computers are set to trust macros signed by you. Then
that prompt will not appear. Not the most secure way to do things
since they can untrust you as well....

Random
 
I'm not the authority on Excel but the only way to disable the dialog box is
to set the security level to low under Tools/Macro/Security or
Tools/Options/Security for Excel XP.

If that's not good enough, here are a couple of my ideas:
- encrypt the workbook and decrypt if authenticaticated
- hide the sheets and password protect the workbook, unprotect and show
sheets if authenticated
- use xla and move the sheets there, copy the sheets to a dummy workbook if
authenticated

....kiat
 
Back
Top