Cell Indicator Problem
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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

--


Gary


"mtm4300 via OfficeKB.com" <u18572@uwe wrote in message
news:5d023d41e4089@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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.

Gary Keramidas wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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

Cell Indicator Problem
 

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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

--


Gary


"mtm4300 via OfficeKB.com" <u18572@uwe wrote in message
news:5d03128269ee0@uwe...
IYes, but I dont want the indicator shown on the screen. Is it possible to
eliminate the indicator?

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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

Cell Indicator Problem
 

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?


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

--
Message posted via http://www.officekb.com

Cell Indicator Problem
 

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?

--


Gary


"mtm4300 via OfficeKB.com" <u18572@uwe wrote in message
news:5d0bb6c24002b@uwe...
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?


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

--
Message posted via http://www.officekb.com

Cell Indicator Problem
 

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

Cell Indicator Problem
 

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 wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

Hi,
Right click that worksheet's sheet tab then select "View code".
This takes you to the VBA Editor.
In the VBA Editor go ViewProperties 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

Cell Indicator Problem
 

Thank You!

Ken Johnson wrote:
Hi,
Right click that worksheet's sheet tab then select "View code".
This takes you to the VBA Editor.
In the VBA Editor go ViewProperties 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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

Cell Indicator Problem
 

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