Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macros
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 !!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macros
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", 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 "Joseph" wrote in message ... 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 !!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macros
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 On Sat, 23 Aug 2003 05:44:10 -0700, "Joseph" wrote: 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 !!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macros
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 "Joseph" wrote in message ... 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 !!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macros Pop-Up | Excel Discussion (Misc queries) | |||
Disable/Enable Macros Message box in Excel2007 | Excel Discussion (Misc queries) | |||
Bypassing ENABLE/DISABLE MACROS message | Excel Discussion (Misc queries) | |||
Enable/Disable macros | Excel Discussion (Misc queries) | |||
Enable/Disable Macros | Excel Discussion (Misc queries) |