DadiCool
06-03-2012, 07:43 AM
Hello,
I have to protect Sheet and VBAProject before deploying the Excel file for end users. (They cannot change anything, otherwize I can not give them support).
Time to time, when user try to run Macro, they have an error message ...
I have to unprotect VBAProject and unselect Missing lines , and the macro works..
I try to found a solution to check by Macro if Some lines are missed, and unselect them automatically (at the start of the Macro).
The missing lines are always about "Client Access Expres", all users have it installed, because the use of Macro is uploading information to the host system (IBM. AS400), and Client Access Express is the program we use to Emulate session on this Host.
(See attached file with different screen)
If someone can help.
Thanks in advance
I have to protect Sheet and VBAProject before deploying the Excel file for end users. (They cannot change anything, otherwize I can not give them support).
Time to time, when user try to run Macro, they have an error message ...
I have to unprotect VBAProject and unselect Missing lines , and the macro works..
I try to found a solution to check by Macro if Some lines are missed, and unselect them automatically (at the start of the Macro).
The missing lines are always about "Client Access Expres", all users have it installed, because the use of Macro is uploading information to the host system (IBM. AS400), and Client Access Express is the program we use to Emulate session on this Host.
(See attached file with different screen)
If someone can help.
Thanks in advance