in-cell drop-down arrow missing
 

When creating a specified list on the same worksheet and in the same workbook
and having checked the in-cell drop-down option, the validated cell does not
show the in-cell drop-down arrow. I have tried the toolscustomize option and
still nothing, I even tried in a new workbook and still nothing. Can anybody
assist please.......

Hi retep

Do you use Window freeze panes and Excel 97 ???

--
Regards Ron de Bruin
http://www.rondebruin.nl


"retep" wrote in message ...
When creating a specified list on the same worksheet and in the same workbook
and having checked the in-cell drop-down option, the validated cell does not
show the in-cell drop-down arrow. I have tried the toolscustomize option and
still nothing, I even tried in a new workbook and still nothing. Can anybody
assist please.......

Any chance that you're using "Freeze Panes"?

In some versions, if the validated cell is *IN* the "frozen" section, the
list becomes inoperable.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"retep" wrote in message
...
When creating a specified list on the same worksheet and in the same
workbook
and having checked the in-cell drop-down option, the validated cell does
not
show the in-cell drop-down arrow. I have tried the toolscustomize option
and
still nothing, I even tried in a new workbook and still nothing. Can
anybody
assist please.......

"Freeze Panes" not being used. Any other suggestions?

Retep

"RagDyer" wrote:

Any chance that you're using "Freeze Panes"?

In some versions, if the validated cell is *IN* the "frozen" section, the
list becomes inoperable.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"retep" wrote in message
...
When creating a specified list on the same worksheet and in the same
workbook
and having checked the in-cell drop-down option, the validated cell does
not
show the in-cell drop-down arrow. I have tried the toolscustomize option
and
still nothing, I even tried in a new workbook and still nothing. Can
anybody
assist please.......

Hey Ron,

Window(XP Home) freeze panes (No - unfrozen) and Excel 97 (Excel 2003)

Any other ideas, I'm stuck in the middle of a project with a "kick - ass"
deadline.

Thnx
Retep (Peter)

"Ron de Bruin" wrote:

Hi retep

Do you use Window freeze panes and Excel 97 ???

--
Regards Ron de Bruin
http://www.rondebruin.nl


"retep" wrote in message ...
When creating a specified list on the same worksheet and in the same workbook
and having checked the in-cell drop-down option, the validated cell does not
show the in-cell drop-down arrow. I have tried the toolscustomize option and
still nothing, I even tried in a new workbook and still nothing. Can anybody
assist please.......

Perhaps objects are hidden.

To show them, choose ToolsOptions
On the View tab, for Objects, choose Show All, or Show Placeholders


retep wrote:
When creating a specified list on the same worksheet and in the same workbook
and having checked the in-cell drop-down option, the validated cell does not
show the in-cell drop-down arrow. I have tried the toolscustomize option and
still nothing, I even tried in a new workbook and still nothing. Can anybody
assist please.......


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Have you try Debra's reply


--
Regards Ron de Bruin
http://www.rondebruin.nl


"retep" wrote in message ...
Hey Ron,

Window(XP Home) freeze panes (No - unfrozen) and Excel 97 (Excel 2003)

Any other ideas, I'm stuck in the middle of a project with a "kick - ass"
deadline.

Thnx
Retep (Peter)

"Ron de Bruin" wrote:

Hi retep

Do you use Window freeze panes and Excel 97 ???

--
Regards Ron de Bruin
http://www.rondebruin.nl


"retep" wrote in message ...
When creating a specified list on the same worksheet and in the same workbook
and having checked the in-cell drop-down option, the validated cell does not
show the in-cell drop-down arrow. I have tried the toolscustomize option and
still nothing, I even tried in a new workbook and still nothing. Can anybody
assist please.......