Cells turn 'hot' and execute distant macro button
 

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? Ive 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 doesnt have any
effect. Oh, and once either the protection, or the autofilter is turned off
the area ios no longer €œhot€�.

Puzzle that one! :-)

Cells turn 'hot' and execute distant macro button
 

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



"Kevryl" wrote:

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? Ive 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 doesnt have any
effect. Oh, and once either the protection, or the autofilter is turned off
the area ios no longer €œhot€�.

Puzzle that one! :-)