Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default cursor/selected cell position after protecting
I noticed that once a document is protected (with user only allowed to select
unlocked cells), the first unprotected cell appears selected. Normally, this would be fine, except that I have a situation where the first unlocked cell is visibible only under rare circumstances, when the value of another cell is say lower than 3. I did this w/ conditional formulas and it works just great. The problem is that when I protect the sheet, that "invisible" cell gets highlighted and even shows the dropdown menu arrow. It does not show the formatting, cell content or outline, but it looks pretty funny and sort of defies the purpose of having the cell hidden.... I don't want the user to even know the cell w/ menu is there except for very few circumstances. Is there any way to "bypass" this default, and to make the first cell selected (after protection) be another unlocked cell, and not this one? Thanks ya'll |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to find position of the contents of a cell within a column. | Excel Discussion (Misc queries) | |||
Relative Cell position NOT working with or without macro | Excel Discussion (Misc queries) | |||
Default cell alignment | Excel Discussion (Misc queries) | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
Default cell format | Excel Discussion (Misc queries) |