This workbook could be a single workbook with VBA or an Addin file.
In corporate environment we/developer create some custom workbooks for automation. In future, we may leave the organization, excel code architecture may change and our created code can create errors or wrong tasks for those workbooks. Since VBE codes are usually password protected, user(less/no vba knowledge) need a easy way to disable our macros/ codes in workbook/addin completely and keep working with the workbook as if no macros were there.
Disable macro at starting of the file is an easy solution. But sometimes inexperienced users enables macros by mistake and problem may occur.
I was thinking of creating a named range in a sheet. In each called macros, I check if named range value(yes, no) and then go on with the code, else do nothing. User changes the value to "No" and all macros/vba/function stops working.
Before implementing this, I need your suggestion and how do you deal with similar situation?
In corporate environment we/developer create some custom workbooks for automation. In future, we may leave the organization, excel code architecture may change and our created code can create errors or wrong tasks for those workbooks. Since VBE codes are usually password protected, user(less/no vba knowledge) need a easy way to disable our macros/ codes in workbook/addin completely and keep working with the workbook as if no macros were there.
Disable macro at starting of the file is an easy solution. But sometimes inexperienced users enables macros by mistake and problem may occur.
I was thinking of creating a named range in a sheet. In each called macros, I check if named range value(yes, no) and then go on with the code, else do nothing. User changes the value to "No" and all macros/vba/function stops working.
Before implementing this, I need your suggestion and how do you deal with similar situation?
