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! :-)