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

XL2003 on XP

I have several files created by a macro that exhibit strange behavior of the
active cell indicator that seems to be associated with a workbook open event.
When the file in question opens after enabling macros, there is no active
cell indicator visible on the cell corresponding to that listed in the Name
Box, and there is no indication in the row/column headers that any cell is
selected. If another cell is selected, there are two active cell indicators;
one in the new cell and one in the original cell. If you go back and select
the original cell, the indicator again disappears. If you switch worksheets
and come back, the problem goes away. If you look at the help file, the
problem goes away. If you change the Zoom, the problem goes away. If you
scroll the problem cell out of view and bring it back, the problem goes away.

I have reduced the workbook_open event to simply unprotecting and protecting
all the worksheets, and this behavior persists.

Private Sub Workbook_open()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Unprotect
ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Next ws
End Sub

If I remove the workbook_open macro (or disable macros when opening the
file), the indicator behaves normally. The problem repeats on other
machines, so it seems to be independent of my hardware. To my knowledge,
there are no user controls on the active cell indicator. So does anyone have
any idea what can cause this?

--
Al C
 
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
Populate Cell Date Value with Active X Calendar Control Jim Lawrence Excel Worksheet Functions 1 February 13th 09 04:20 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:41 AM.

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"