A
Al
XL2003 on XP
This is a follow-up to a previous post. I have a set of files created by a
macro that exhibit strange behavior of the active cell indicator associated
with a particular workbook open event. When any of these files are opened,
the active cell indicator is not visible until you do something that causes
that cell to be redrawn. Until then, the indicator behaves as if a bit
controlling its visibility is inverted on the initial active cell. If you
select that cell, there is no indicator. Select another cell and you get two
active cell indicators. Normally, if you open some other reduced size window
over the workbook, the active cell indicator gets turned off. This one gets
turned on. If you cover part of the errant cell indicator with this window
and then shift the focus back to the original workbook, the portion of the
indicator border that was covered will be right and the rest of it is still
wrong.
The workbook open event that leads to this is reduced to a single loop that
just unprotects and then protects all the sheets in the workbook. However,
when I break that into two separate loops, the problem goes away. That gives
me a workaround, but none of this makes any sense to me at all. We have done
a total reinstall of the Microsoft Office suite, and I still get the same
results. I’m forced to conclude that the macro that creates these files is
causing the problem, but I can’t imagine how or even why my workaround fixes
it. Does anyone have a clue as to what’s going on, or is this even the forum
for my question?
This is a follow-up to a previous post. I have a set of files created by a
macro that exhibit strange behavior of the active cell indicator associated
with a particular workbook open event. When any of these files are opened,
the active cell indicator is not visible until you do something that causes
that cell to be redrawn. Until then, the indicator behaves as if a bit
controlling its visibility is inverted on the initial active cell. If you
select that cell, there is no indicator. Select another cell and you get two
active cell indicators. Normally, if you open some other reduced size window
over the workbook, the active cell indicator gets turned off. This one gets
turned on. If you cover part of the errant cell indicator with this window
and then shift the focus back to the original workbook, the portion of the
indicator border that was covered will be right and the rest of it is still
wrong.
The workbook open event that leads to this is reduced to a single loop that
just unprotects and then protects all the sheets in the workbook. However,
when I break that into two separate loops, the problem goes away. That gives
me a workaround, but none of this makes any sense to me at all. We have done
a total reinstall of the Microsoft Office suite, and I still get the same
results. I’m forced to conclude that the macro that creates these files is
causing the problem, but I can’t imagine how or even why my workaround fixes
it. Does anyone have a clue as to what’s going on, or is this even the forum
for my question?