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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Indicator Problem
Hi mtm,
you're welcome, thanks for the feedback. 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 |