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 restrict 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