Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 363
Default Update on out of control Active Cell Indicator

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change direction active cell indicator moves when enter key is pre ldavidm Excel Discussion (Misc queries) 2 September 20th 09 03:49 PM
Out of control Active Cell Indicator Al Excel Programming 4 December 1st 08 01:01 PM
Active cell with a "crosshair" indicator ? KarenY Excel Discussion (Misc queries) 6 March 12th 08 04:32 PM
active cell control using scripts Robin01 Excel Programming 1 July 19th 06 12:42 AM
How to change the active cell outline indicator color in Excel? YoYo74 Excel Discussion (Misc queries) 2 January 11th 06 02:37 PM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"