Cells turn 'hot' and execute distant macro button

[Guest]

I have a very strange situation. In my purchase order sheet:

Rows 1 and 2 are in the “freeze pain area†and contain macro buttons.

One of the macro buttons erazes the orders column data.
One of the macros applies autofilter to hide rows with blank cells in one
column.
All macros remove and apply worksheet protection at start and end
respectively.

After executing the macro that applies autofilter, that filter condition
remains after protection is turned back on and the macro ended. NOW, at this
point, any area in row 2 is “hot†and upon clicking executes the “erazeâ€
macro, which is actually physically well-removed from the macro button
(icreated through the forms menu).

Anyone any thoughts on why this is so? I’ve puzzled as to why I lost a
couple of lengthy orders until I realised it was caused by this. Opening a
transparent text box as a “botch†to cover the 'hot' area doesn’t have any
effect. Oh, and once either the protection, or the autofilter is turned off
the area ios no longer “hotâ€.

Puzzle that one!

 

[Guest]

If it's just one ROW that is manifesting the problem, then I would (working
with a copy of course), just delete that ROW, and then re-insert it and
re-create any data that was in it........if the problem returns upon running
the macros, then apparently one or both of them contain code to set the
condition up..........one would have to examine the code.

hth
Vaya con Dios,
Chuck, CABGx3