validation question

The drop down is available when you select the "List" validation.

If you have chosen the "List" validation, then ensure the "In-cell drop-down" checkbox is checked, otherwise there will be no drop down available.

Incell drop down ticked..
I have used this function many times before, the strange thing being that it
works fine on other pages within the workbook..

Feel i have something swithced off in options or view but cannot see
anything that works..



"Vito" wrote:

>
> The drop down is available when you select the "List" validation.
>
> If you have chosen the "List" validation, then ensure the "In-cell
> drop-down" checkbox is checked, otherwise there will be no drop down
> available.
>
>
> --
> Vito
> ------------------------------------------------------------------------
> Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
> View this thread: http://www.excelforum.com/showthread...hreadid=503885
>
>

"G" wrote
> ... Incell drop down ticked..
> I have used this function many times before,
> the strange thing being that it works fine on other pages
> within the workbook..
> Feel i have something switched off in options or view
> but cannot see anything that works..

Are you using Excel 97?
Just to share some thoughts .. (no solution to offer, sorry).
I've experienced this phenomena before in Excel 97 (my ver)
One particular sheet just went "poof" one fine day while working in Excel.
All existing DV droplists just plain disappeared. And new DVs created
stubbornly refused to show the droplists in the sheet. Had no choice then
but to revert to my last back-up (in which the existing DVs still worked in
that particular sheet), and recover / re-work from there ( .. was thankful I
did the back-ups .. )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

If you had some code for deleting shapes, it is possible that you deleted
the arrow shape inadvertently.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"G" <G@discussions.microsoft.com> wrote in message
news:360FCF78-8A58-4826-99C9-8FF40EB6D5B6@microsoft.com...
> Incell drop down ticked..
> I have used this function many times before, the strange thing being that
it
> works fine on other pages within the workbook..
>
> Feel i have something swithced off in options or view but cannot see
> anything that works..
>
>
>
> "Vito" wrote:
>
> >
> > The drop down is available when you select the "List" validation.
> >
> > If you have chosen the "List" validation, then ensure the "In-cell
> > drop-down" checkbox is checked, otherwise there will be no drop down
> > available.
> >
> >
> > --
> > Vito
> > ------------------------------------------------------------------------
> > Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
> > View this thread:
http://www.excelforum.com/showthread...hreadid=503885
> >
> >

Bob, I couldn't help having a deja vu` feeling <g>,
re - similar discussions with Dave Peterson in 6/2004:
http://tinyurl.com/d3las
(.. and I swear there wasn't any code in use)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Max,

So did I when I read this. Dave and I also had a discussion in Mar 2005

http://tinyurl.com/de4cx

Not a solution IAF, but a way to ensure your code doesn't cause it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Max" <demechanik@yahoo.com> wrote in message
news:eUEJUbAIGHA.2012@TK2MSFTNGP14.phx.gbl...
> Bob, I couldn't help having a deja vu` feeling <g>,
> re - similar discussions with Dave Peterson in 6/2004:
> http://tinyurl.com/d3las
> (.. and I swear there wasn't any code in use)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
>
>

"Bob Phillips" wrote:
> .. Dave and I also had a discussion in Mar 2005
*> http://tinyurl.com/de4cx

Yes, I do recollect that thread .. strung along a bit later there

> Not a solution IAF, but a way to ensure your code doesn't cause it.

The precautions/code offered are well taken, and appreciated.

Thankfully, this "event" hasn't recurred since to me (touch wood ..). It'll
be great though, if there was code available which could re-instate the
"lost" DV dropdown functionality in the sheet, whatever its underlying
cause(s) may be.
---
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"Max" <demechanik@yahoo.com> wrote in message
news:utyz6cIIGHA.1836@TK2MSFTNGP11.phx.gbl...
> "Bob Phillips" wrote:
> > .. Dave and I also had a discussion in Mar 2005
> *> http://tinyurl.com/de4cx

> Thankfully, this "event" hasn't recurred since to me (touch wood ..).
It'll
> be great though, if there was code available which could re-instate the
> "lost" DV dropdown functionality in the sheet, whatever its underlying
> cause(s) may be.

Unfortunately that is the thing that nobody has been able to do AFAIK.