Why do I lose data in column after clicking on macro?

[kajero52]

I inserted a macro button to turn filter on or off. After I click on the macro button the word Apex disappears. Why does this happen and how can I prevent it?

 

[Micron]

Impossible to do more than provide a vague guess without seeing the code. If you intend to post code, please copy it, then click vba button on posting toolbar, then paste your code where the cursor would be (in between the code tags you just created). You would do that any time you want someone to troubleshoot your code.

EDIT - in this case the code I refer to is your button click event code.

 

[kajero52]

I will try to this! I am not that well versed in VBA. Thanks for helping!