Comment blocks of code using vba

Hello everyone

I have a worksheet_SelectionChange event in a sheet
I need VBA solution to put blocks of comments on the code to disable it and another code to enable the code and clear comments
In other words without logging into VBE I need to put comments on all the lines of code
and another code does the contrast to remove comments which were put on the code

I hope it is clear

Hi,
Not sure this is feasible easily. What are you trying to achieve?
It it's to run the code only in certain conditions, why not use a IF THEN ELSE ?

Thanka lot for reply Mr. GC Excel
I just need to disable the events in the code for some time and enable again..
It's not related to the code itself .. It's a general idea ..
I imagine two buttons : one for putting comments on the specific code in worksheet_selectionchange and another button to remove comments

I'm pretty sure there are other ways to prevent code being executed.

For example you could turn off events using this.

Please Login or Register  to view this content.

That could be applied based on any criteria you have.

Hi,

Couple Norie's suggestion in #4 with the If..Then idea in #2 and set a public variable with your buttons that can be read by the IF test.