| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! :-) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
