Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. Im forced to conclude that the macro that creates these files is causing the problem, but I cant imagine how or even why my workaround fixes it. Does anyone have a clue as to whats going on, or is this even the forum for my question? -- Al C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change direction active cell indicator moves when enter key is pre | Excel Discussion (Misc queries) | |||
Out of control Active Cell Indicator | Excel Programming | |||
Active cell with a "crosshair" indicator ? | Excel Discussion (Misc queries) | |||
active cell control using scripts | Excel Programming | |||
How to change the active cell outline indicator color in Excel? | Excel Discussion (Misc queries) |