Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Indicator Problem
Hi,
If the cells are locked and the sheet's protected then the user can't delete the data. Ken Johnson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indicator to show formula cell | Excel Discussion (Misc queries) | |||
cell indicator flag | Excel Worksheet Functions | |||
Cell indicator | Excel Discussion (Misc queries) | |||
Return activie cell indicator to column A next row down. | Excel Discussion (Misc queries) | |||
How do I change the color of the indicator cell in row and column | Excel Worksheet Functions |