Cell Indicator Problem

[mtm4300 via OfficeKB.com]

I do not want the cell indicator to appear on my worksheet. The worksheet is
protected and all of the cells are locked. When I protect my sheet, the cell
indicator disappears. However, when I reopen my file, the cell indicator
appears on a locked and protected cell. I have tried to click on a cell
outside of the viewing area before protecting the sheet, but when I open the
file it goes to that cell. Is there a macro that will eliminate the cell
indicator? Is there anyway I can solve this problem? Any help will be greatly
appreciated.

 

[Gary Keramidas]

go to tools/options/error checking and uncheck the box for unlocked cells
containing formula

 

[mtm4300 via OfficeKB.com]

The indicator is still showing on the screen. The sheet doesnt contain any
formulas. It contains data that the user will need to use on another sheet. I
dont want the user to accidently delete the data, therefore I protected the
sheet.

go to tools/options/error checking and uncheck the box for unlocked cells
containing formula

I do not want the cell indicator to appear on my worksheet. The worksheet is
protected and all of the cells are locked. When I protect my sheet, the cell

[quoted text clipped - 4 lines]

indicator? Is there anyway I can solve this problem? Any help will be greatly
appreciated.

 

[Ken Johnson]

Hi,
If the cells are locked and the sheet's protected then the user can't
delete the data.
Ken Johnson

 

[mtm4300 via OfficeKB.com]

IYes, but I dont want the indicator shown on the screen. Is it possible to
eliminate the indicator?

 

[Gary Keramidas]

are they numbers stored as text? we need to know what the data is.

 

[Ken Johnson]

Hi,
that option appears in the protect sheet dialog in Excel 2003, so I
guess you must be using an earlier version.
Ken Johnson

 

[mtm4300 via OfficeKB.com]

They are numbers stored as text. The cell indicator appears after I reopen
the file after I have protected it. The user cannot click anywhere in the
sheet, therefore the indicator is locked on one certain cell. I have tried to
be sneaky and clicked on an empty cell, and then hid the row and column, but
it still leaves a black dot on the screen. I have also tried to click outside
of the viewing area (ie. AA1 or something far away from the cells with data)
but the sheet loads to the active cell.

My version is 2002. Does anyone know how to eliminate the problem?

 

[Gary Keramidas]

i don't have that version, i have 2003. don't you have an option to uncheck for
numbers stored as text on the options tab i mentioned in my other post?

 

[Ken Johnson]

I'm confused.
What is the cell indicator?
I thought it was just the thicker border surrounding the selected
range.
Is it the little icon that appears next to cells with potential
problems?
Ken Johnson

 

[mtm4300 via OfficeKB.com]

It is the thicker border around the cell. But for some reason it becomes
locked on the screen after I protect and reopen the file. And I havent found
an option in Excel 2002 to rid the indicator.

 

[Ken Johnson]

Hi,
Right click that worksheet's sheet tab then select "View code".
This takes you to the VBA Editor.
In the VBA Editor go View>Properties window.
In the lefthand column of that worksheet's Properties window find and
select "EnableSelection". In the righthand column on the same line
click on the dropdown arrow and select "-4142 - xlNoSelection".
Press Alt + F11 to return to the worksheet and you should have the
desired result.

Ken Johnson

 

[mtm4300 via OfficeKB.com]

Thank You!

Hi,
Right click that worksheet's sheet tab then select "View code".
This takes you to the VBA Editor.
In the VBA Editor go View>Properties window.
In the lefthand column of that worksheet's Properties window find and
select "EnableSelection". In the righthand column on the same line
click on the dropdown arrow and select "-4142 - xlNoSelection".
Press Alt + F11 to return to the worksheet and you should have the
desired result.

Ken Johnson

 

[Ken Johnson]

Hi mtm,
you're welcome, thanks for the feedback.
Ken Johnson