Hi

Deactivate is a sheet specific macro name.

So you need to save your code in the sheet specific area.

Right click pn the sheet name at the bottom of excel

On left tab select worksheet

on right tab select deactivate

paste you code between Sub and end sub.