Hi all,
I'm looking for a way to prevent a macro from being run on certain worksheets. In my workbook, there different types of sheets that I have made, for example Buying, Selling, etc...
Say I want to have allow a macro to run only on the Buying worksheets, is there a way to do this in code. Ideally, I want code it in such a way that it is transparent to the user, for example a CustomProperty or a variable within the code for a sheet that I can look up.
Many thanks in advance.
Best regards,
Chun Te
I'm looking for a way to prevent a macro from being run on certain worksheets. In my workbook, there different types of sheets that I have made, for example Buying, Selling, etc...
Say I want to have allow a macro to run only on the Buying worksheets, is there a way to do this in code. Ideally, I want code it in such a way that it is transparent to the user, for example a CustomProperty or a variable within the code for a sheet that I can look up.
Many thanks in advance.
Best regards,
Chun Te