Drop-down arrow (Data-Validation-List) disappears (Excel 2003)

On Wed, 24 Aug 2005 03:46:03 -0700, "CaraVanTea"
<[email protected]> wrote:

>Hi,
>
>I'm very much used to working with the different possibilities of the
>Data-Validation feature and am pretty satisfied with it. Nevertheless for no
>apparent reason sometimes the arrow indicating that there is a dropdown-list
>available disappears. Strange enough the parameters are yet correct (eg. the
>zone determining the cells to appear in the list is still correct).
>
>Has anyone an explanation/solution for this problem?

I don't suppose the In-cell dropdown option has become de-selected?


--ron

Hi,

I'm very much used to working with the different possibilities of the
Data-Validation feature and am pretty satisfied with it. Nevertheless for no
apparent reason sometimes the arrow indicating that there is a dropdown-list
available disappears. Strange enough the parameters are yet correct (eg. the
zone determining the cells to appear in the list is still correct).

Has anyone an explanation/solution for this problem?

Have you run any code to delete shapes, buttons or such like?

--
HTH

Bob Phillips

"CaraVanTea" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm very much used to working with the different possibilities of the
> Data-Validation feature and am pretty satisfied with it. Nevertheless for
no
> apparent reason sometimes the arrow indicating that there is a
dropdown-list
> available disappears. Strange enough the parameters are yet correct (eg.
the
> zone determining the cells to appear in the list is still correct).
>
> Has anyone an explanation/solution for this problem?

Hi Ron,

No, the "in-cell dropdown" remains selected.

"Ron Rosenfeld" a écrit :

> On Wed, 24 Aug 2005 03:46:03 -0700, "CaraVanTea"
> <[email protected]> wrote:
>
> >Hi,
> >
> >I'm very much used to working with the different possibilities of the
> >Data-Validation feature and am pretty satisfied with it. Nevertheless for no
> >apparent reason sometimes the arrow indicating that there is a dropdown-list
> >available disappears. Strange enough the parameters are yet correct (eg. the
> >zone determining the cells to appear in the list is still correct).
> >
> >Has anyone an explanation/solution for this problem?
>
> I don't suppose the In-cell dropdown option has become de-selected?
>
>
> --ron
>

Neither nor. No specific or complexe intervention was executed on the file.

"Bob Phillips" a écrit :

> Have you run any code to delete shapes, buttons or such like?
>
> --
> HTH
>
> Bob Phillips
>
> "CaraVanTea" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I'm very much used to working with the different possibilities of the
> > Data-Validation feature and am pretty satisfied with it. Nevertheless for
> no
> > apparent reason sometimes the arrow indicating that there is a
> dropdown-list
> > available disappears. Strange enough the parameters are yet correct (eg.
> the
> > zone determining the cells to appear in the list is still correct).
> >
> > Has anyone an explanation/solution for this problem?
>
>
>

Hi

Haven't you used Freeze Panes with column with data validation as rightmost
fixed one?


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )


"CaraVanTea" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm very much used to working with the different possibilities of the
> Data-Validation feature and am pretty satisfied with it. Nevertheless for
> no
> apparent reason sometimes the arrow indicating that there is a
> dropdown-list
> available disappears. Strange enough the parameters are yet correct (eg.
> the
> zone determining the cells to appear in the list is still correct).
>
> Has anyone an explanation/solution for this problem?

Hi Arvi,

No, nor Freeze Panes nor Split Windows. Is there any way I could send you
guys the file in question? (am for the first time on this discussion forum)


"Arvi Laanemets" a écrit :

> Hi
>
> Haven't you used Freeze Panes with column with data validation as rightmost
> fixed one?
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvil<at>tarkon.ee )
>
>
> "CaraVanTea" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I'm very much used to working with the different possibilities of the
> > Data-Validation feature and am pretty satisfied with it. Nevertheless for
> > no
> > apparent reason sometimes the arrow indicating that there is a
> > dropdown-list
> > available disappears. Strange enough the parameters are yet correct (eg.
> > the
> > zone determining the cells to appear in the list is still correct).
> >
> > Has anyone an explanation/solution for this problem?
>
>
>

I am happy to take a look. Note the spam filter in my addy which needs to be
removed - the nothere

--
HTH

Bob Phillips

"CaraVanTea" <[email protected]> wrote in message
news:[email protected]...
> Hi Arvi,
>
> No, nor Freeze Panes nor Split Windows. Is there any way I could send you
> guys the file in question? (am for the first time on this discussion
forum)
>
>
> "Arvi Laanemets" a écrit :
>
> > Hi
> >
> > Haven't you used Freeze Panes with column with data validation as
rightmost
> > fixed one?
> >
> >
> > --
> > Arvi Laanemets
> > ( My real mail address: arvil<at>tarkon.ee )
> >
> >
> > "CaraVanTea" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi,
> > >
> > > I'm very much used to working with the different possibilities of the
> > > Data-Validation feature and am pretty satisfied with it. Nevertheless
for
> > > no
> > > apparent reason sometimes the arrow indicating that there is a
> > > dropdown-list
> > > available disappears. Strange enough the parameters are yet correct
(eg.
> > > the
> > > zone determining the cells to appear in the list is still correct).
> > >
> > > Has anyone an explanation/solution for this problem?
> >
> >
> >

I posted it to you a moment ago - hope it went through well.

Thanks in advance for having a look at it.

"Bob Phillips" a écrit :

> I am happy to take a look. Note the spam filter in my addy which needs to be
> removed - the nothere
>
> --
> HTH
>
> Bob Phillips
>
> "CaraVanTea" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Arvi,
> >
> > No, nor Freeze Panes nor Split Windows. Is there any way I could send you
> > guys the file in question? (am for the first time on this discussion
> forum)
> >
> >
> > "Arvi Laanemets" a écrit :
> >
> > > Hi
> > >
> > > Haven't you used Freeze Panes with column with data validation as
> rightmost
> > > fixed one?
> > >
> > >
> > > --
> > > Arvi Laanemets
> > > ( My real mail address: arvil<at>tarkon.ee )
> > >
> > >
> > > "CaraVanTea" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hi,
> > > >
> > > > I'm very much used to working with the different possibilities of the
> > > > Data-Validation feature and am pretty satisfied with it. Nevertheless
> for
> > > > no
> > > > apparent reason sometimes the arrow indicating that there is a
> > > > dropdown-list
> > > > available disappears. Strange enough the parameters are yet correct
> (eg.
> > > > the
> > > > zone determining the cells to appear in the list is still correct).
> > > >
> > > > Has anyone an explanation/solution for this problem?
> > >
> > >
> > >
>
>
>

Have you look in Tools>Options View
See the Objects line


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


"CaraVanTea" <[email protected]> wrote in message news:[email protected]...
>I posted it to you a moment ago - hope it went through well.
>
> Thanks in advance for having a look at it.
>
> "Bob Phillips" a écrit :
>
>> I am happy to take a look. Note the spam filter in my addy which needs to be
>> removed - the nothere
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> "CaraVanTea" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi Arvi,
>> >
>> > No, nor Freeze Panes nor Split Windows. Is there any way I could send you
>> > guys the file in question? (am for the first time on this discussion
>> forum)
>> >
>> >
>> > "Arvi Laanemets" a écrit :
>> >
>> > > Hi
>> > >
>> > > Haven't you used Freeze Panes with column with data validation as
>> rightmost
>> > > fixed one?
>> > >
>> > >
>> > > --
>> > > Arvi Laanemets
>> > > ( My real mail address: arvil<at>tarkon.ee )
>> > >
>> > >
>> > > "CaraVanTea" <[email protected]> wrote in message
>> > > news:[email protected]...
>> > > > Hi,
>> > > >
>> > > > I'm very much used to working with the different possibilities of the
>> > > > Data-Validation feature and am pretty satisfied with it. Nevertheless
>> for
>> > > > no
>> > > > apparent reason sometimes the arrow indicating that there is a
>> > > > dropdown-list
>> > > > available disappears. Strange enough the parameters are yet correct
>> (eg.
>> > > > the
>> > > > zone determining the cells to appear in the list is still correct).
>> > > >
>> > > > Has anyone an explanation/solution for this problem?
>> > >
>> > >
>> > >
>>
>>
>>

Hi Ron,

The "Tools>Options>View" is on "Show all". Guess that's correct.

"Ron de Bruin" a écrit :

> Have you look in Tools>Options View
> See the Objects line
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "CaraVanTea" <[email protected]> wrote in message news:[email protected]...
> >I posted it to you a moment ago - hope it went through well.
> >
> > Thanks in advance for having a look at it.
> >
> > "Bob Phillips" a écrit :
> >
> >> I am happy to take a look. Note the spam filter in my addy which needs to be
> >> removed - the nothere
> >>
> >> --
> >> HTH
> >>
> >> Bob Phillips
> >>
> >> "CaraVanTea" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hi Arvi,
> >> >
> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could send you
> >> > guys the file in question? (am for the first time on this discussion
> >> forum)
> >> >
> >> >
> >> > "Arvi Laanemets" a écrit :
> >> >
> >> > > Hi
> >> > >
> >> > > Haven't you used Freeze Panes with column with data validation as
> >> rightmost
> >> > > fixed one?
> >> > >
> >> > >
> >> > > --
> >> > > Arvi Laanemets
> >> > > ( My real mail address: arvil<at>tarkon.ee )
> >> > >
> >> > >
> >> > > "CaraVanTea" <[email protected]> wrote in message
> >> > > news:[email protected]...
> >> > > > Hi,
> >> > > >
> >> > > > I'm very much used to working with the different possibilities of the
> >> > > > Data-Validation feature and am pretty satisfied with it. Nevertheless
> >> for
> >> > > > no
> >> > > > apparent reason sometimes the arrow indicating that there is a
> >> > > > dropdown-list
> >> > > > available disappears. Strange enough the parameters are yet correct
> >> (eg.
> >> > > > the
> >> > > > zone determining the cells to appear in the list is still correct).
> >> > > >
> >> > > > Has anyone an explanation/solution for this problem?
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
>

Yes that is correct.

Have Bob reply to you when you send him the workbook?

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


"CaraVanTea" <[email protected]> wrote in message news:[email protected]...
> Hi Ron,
>
> The "Tools>Options>View" is on "Show all". Guess that's correct.
>
> "Ron de Bruin" a écrit :
>
>> Have you look in Tools>Options View
>> See the Objects line
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "CaraVanTea" <[email protected]> wrote in message news:[email protected]...
>> >I posted it to you a moment ago - hope it went through well.
>> >
>> > Thanks in advance for having a look at it.
>> >
>> > "Bob Phillips" a écrit :
>> >
>> >> I am happy to take a look. Note the spam filter in my addy which needs to be
>> >> removed - the nothere
>> >>
>> >> --
>> >> HTH
>> >>
>> >> Bob Phillips
>> >>
>> >> "CaraVanTea" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > Hi Arvi,
>> >> >
>> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could send you
>> >> > guys the file in question? (am for the first time on this discussion
>> >> forum)
>> >> >
>> >> >
>> >> > "Arvi Laanemets" a écrit :
>> >> >
>> >> > > Hi
>> >> > >
>> >> > > Haven't you used Freeze Panes with column with data validation as
>> >> rightmost
>> >> > > fixed one?
>> >> > >
>> >> > >
>> >> > > --
>> >> > > Arvi Laanemets
>> >> > > ( My real mail address: arvil<at>tarkon.ee )
>> >> > >
>> >> > >
>> >> > > "CaraVanTea" <[email protected]> wrote in message
>> >> > > news:[email protected]...
>> >> > > > Hi,
>> >> > > >
>> >> > > > I'm very much used to working with the different possibilities of the
>> >> > > > Data-Validation feature and am pretty satisfied with it. Nevertheless
>> >> for
>> >> > > > no
>> >> > > > apparent reason sometimes the arrow indicating that there is a
>> >> > > > dropdown-list
>> >> > > > available disappears. Strange enough the parameters are yet correct
>> >> (eg.
>> >> > > > the
>> >> > > > zone determining the cells to appear in the list is still correct).
>> >> > > >
>> >> > > > Has anyone an explanation/solution for this problem?
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>>
>>
>>

never got it.

--
HTH

Bob Phillips

"Ron de Bruin" <[email protected]> wrote in message
news:[email protected]...
> Yes that is correct.
>
> Have Bob reply to you when you send him the workbook?
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "CaraVanTea" <[email protected]> wrote in message
news:[email protected]...
> > Hi Ron,
> >
> > The "Tools>Options>View" is on "Show all". Guess that's correct.
> >
> > "Ron de Bruin" a écrit :
> >
> >> Have you look in Tools>Options View
> >> See the Objects line
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "CaraVanTea" <[email protected]> wrote in message
news:[email protected]...
> >> >I posted it to you a moment ago - hope it went through well.
> >> >
> >> > Thanks in advance for having a look at it.
> >> >
> >> > "Bob Phillips" a écrit :
> >> >
> >> >> I am happy to take a look. Note the spam filter in my addy which
needs to be
> >> >> removed - the nothere
> >> >>
> >> >> --
> >> >> HTH
> >> >>
> >> >> Bob Phillips
> >> >>
> >> >> "CaraVanTea" <[email protected]> wrote in message
> >> >> news:[email protected]...
> >> >> > Hi Arvi,
> >> >> >
> >> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could
send you
> >> >> > guys the file in question? (am for the first time on this
discussion
> >> >> forum)
> >> >> >
> >> >> >
> >> >> > "Arvi Laanemets" a écrit :
> >> >> >
> >> >> > > Hi
> >> >> > >
> >> >> > > Haven't you used Freeze Panes with column with data validation
as
> >> >> rightmost
> >> >> > > fixed one?
> >> >> > >
> >> >> > >
> >> >> > > --
> >> >> > > Arvi Laanemets
> >> >> > > ( My real mail address: arvil<at>tarkon.ee )
> >> >> > >
> >> >> > >
> >> >> > > "CaraVanTea" <[email protected]> wrote in
message
> >> >> > > news:[email protected]...
> >> >> > > > Hi,
> >> >> > > >
> >> >> > > > I'm very much used to working with the different possibilities
of the
> >> >> > > > Data-Validation feature and am pretty satisfied with it.
Nevertheless
> >> >> for
> >> >> > > > no
> >> >> > > > apparent reason sometimes the arrow indicating that there is a
> >> >> > > > dropdown-list
> >> >> > > > available disappears. Strange enough the parameters are yet
correct
> >> >> (eg.
> >> >> > > > the
> >> >> > > > zone determining the cells to appear in the list is still
correct).
> >> >> > > >
> >> >> > > > Has anyone an explanation/solution for this problem?
> >> >> > >
> >> >> > >
> >> >> > >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Hi Bob

> never got it.
Ahaaa


Hi CaraVanTea

You can send it to me also if you want.
I use a real mail address in this newsgroup.

I will send it to Bob when I don't see the problem





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


"Bob Phillips" <[email protected]> wrote in message news:[email protected]...
> never got it.
>
> --
> HTH
>
> Bob Phillips
>
> "Ron de Bruin" <[email protected]> wrote in message
> news:[email protected]...
>> Yes that is correct.
>>
>> Have Bob reply to you when you send him the workbook?
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "CaraVanTea" <[email protected]> wrote in message
> news:[email protected]...
>> > Hi Ron,
>> >
>> > The "Tools>Options>View" is on "Show all". Guess that's correct.
>> >
>> > "Ron de Bruin" a écrit :
>> >
>> >> Have you look in Tools>Options View
>> >> See the Objects line
>> >>
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >> "CaraVanTea" <[email protected]> wrote in message
> news:[email protected]...
>> >> >I posted it to you a moment ago - hope it went through well.
>> >> >
>> >> > Thanks in advance for having a look at it.
>> >> >
>> >> > "Bob Phillips" a écrit :
>> >> >
>> >> >> I am happy to take a look. Note the spam filter in my addy which
> needs to be
>> >> >> removed - the nothere
>> >> >>
>> >> >> --
>> >> >> HTH
>> >> >>
>> >> >> Bob Phillips
>> >> >>
>> >> >> "CaraVanTea" <[email protected]> wrote in message
>> >> >> news:[email protected]...
>> >> >> > Hi Arvi,
>> >> >> >
>> >> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could
> send you
>> >> >> > guys the file in question? (am for the first time on this
> discussion
>> >> >> forum)
>> >> >> >
>> >> >> >
>> >> >> > "Arvi Laanemets" a écrit :
>> >> >> >
>> >> >> > > Hi
>> >> >> > >
>> >> >> > > Haven't you used Freeze Panes with column with data validation
> as
>> >> >> rightmost
>> >> >> > > fixed one?
>> >> >> > >
>> >> >> > >
>> >> >> > > --
>> >> >> > > Arvi Laanemets
>> >> >> > > ( My real mail address: arvil<at>tarkon.ee )
>> >> >> > >
>> >> >> > >
>> >> >> > > "CaraVanTea" <[email protected]> wrote in
> message
>> >> >> > > news:[email protected]...
>> >> >> > > > Hi,
>> >> >> > > >
>> >> >> > > > I'm very much used to working with the different possibilities
> of the
>> >> >> > > > Data-Validation feature and am pretty satisfied with it.
> Nevertheless
>> >> >> for
>> >> >> > > > no
>> >> >> > > > apparent reason sometimes the arrow indicating that there is a
>> >> >> > > > dropdown-list
>> >> >> > > > available disappears. Strange enough the parameters are yet
> correct
>> >> >> (eg.
>> >> >> > > > the
>> >> >> > > > zone determining the cells to appear in the list is still
> correct).
>> >> >> > > >
>> >> >> > > > Has anyone an explanation/solution for this problem?
>> >> >> > >
>> >> >> > >
>> >> >> > >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>
>

Okay, I sent it off - trust it worked.


"Ron de Bruin" a écrit :

> Hi Bob
>
> > never got it.
> Ahaaa
>
>
> Hi CaraVanTea
>
> You can send it to me also if you want.
> I use a real mail address in this newsgroup.
>
> I will send it to Bob when I don't see the problem
>
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Bob Phillips" <[email protected]> wrote in message news:[email protected]...
> > never got it.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Ron de Bruin" <[email protected]> wrote in message
> > news:[email protected]...
> >> Yes that is correct.
> >>
> >> Have Bob reply to you when you send him the workbook?
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "CaraVanTea" <[email protected]> wrote in message
> > news:[email protected]...
> >> > Hi Ron,
> >> >
> >> > The "Tools>Options>View" is on "Show all". Guess that's correct.
> >> >
> >> > "Ron de Bruin" a écrit :
> >> >
> >> >> Have you look in Tools>Options View
> >> >> See the Objects line
> >> >>
> >> >>
> >> >> --
> >> >> Regards Ron de Bruin
> >> >> http://www.rondebruin.nl
> >> >>
> >> >>
> >> >> "CaraVanTea" <[email protected]> wrote in message
> > news:[email protected]...
> >> >> >I posted it to you a moment ago - hope it went through well.
> >> >> >
> >> >> > Thanks in advance for having a look at it.
> >> >> >
> >> >> > "Bob Phillips" a écrit :
> >> >> >
> >> >> >> I am happy to take a look. Note the spam filter in my addy which
> > needs to be
> >> >> >> removed - the nothere
> >> >> >>
> >> >> >> --
> >> >> >> HTH
> >> >> >>
> >> >> >> Bob Phillips
> >> >> >>
> >> >> >> "CaraVanTea" <[email protected]> wrote in message
> >> >> >> news:[email protected]...
> >> >> >> > Hi Arvi,
> >> >> >> >
> >> >> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could
> > send you
> >> >> >> > guys the file in question? (am for the first time on this
> > discussion
> >> >> >> forum)
> >> >> >> >
> >> >> >> >
> >> >> >> > "Arvi Laanemets" a écrit :
> >> >> >> >
> >> >> >> > > Hi
> >> >> >> > >
> >> >> >> > > Haven't you used Freeze Panes with column with data validation
> > as
> >> >> >> rightmost
> >> >> >> > > fixed one?
> >> >> >> > >
> >> >> >> > >
> >> >> >> > > --
> >> >> >> > > Arvi Laanemets
> >> >> >> > > ( My real mail address: arvil<at>tarkon.ee )
> >> >> >> > >
> >> >> >> > >
> >> >> >> > > "CaraVanTea" <[email protected]> wrote in
> > message
> >> >> >> > > news:[email protected]...
> >> >> >> > > > Hi,
> >> >> >> > > >
> >> >> >> > > > I'm very much used to working with the different possibilities
> > of the
> >> >> >> > > > Data-Validation feature and am pretty satisfied with it.
> > Nevertheless
> >> >> >> for
> >> >> >> > > > no
> >> >> >> > > > apparent reason sometimes the arrow indicating that there is a
> >> >> >> > > > dropdown-list
> >> >> >> > > > available disappears. Strange enough the parameters are yet
> > correct
> >> >> >> (eg.
> >> >> >> > > > the
> >> >> >> > > > zone determining the cells to appear in the list is still
> > correct).
> >> >> >> > > >
> >> >> >> > > > Has anyone an explanation/solution for this problem?
> >> >> >> > >
> >> >> >> > >
> >> >> >> > >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >
> >
>
>
>

Addendum

Ron,

There's actually another quite strange behaviour: If you doubleclick on the
Column-Width (column A) an error report will be generated. If you open the
restored file afterwards, the dropdown reappears.

Nevertheless it doesn't give me the answer why it disappears in the first
place....

Good luck

"Ron de Bruin" a écrit :

> Hi Bob
>
> > never got it.
> Ahaaa
>
>
> Hi CaraVanTea
>
> You can send it to me also if you want.
> I use a real mail address in this newsgroup.
>
> I will send it to Bob when I don't see the problem
>
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Bob Phillips" <[email protected]> wrote in message news:[email protected]...
> > never got it.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Ron de Bruin" <[email protected]> wrote in message
> > news:[email protected]...
> >> Yes that is correct.
> >>
> >> Have Bob reply to you when you send him the workbook?
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "CaraVanTea" <[email protected]> wrote in message
> > news:[email protected]...
> >> > Hi Ron,
> >> >
> >> > The "Tools>Options>View" is on "Show all". Guess that's correct.
> >> >
> >> > "Ron de Bruin" a écrit :
> >> >
> >> >> Have you look in Tools>Options View
> >> >> See the Objects line
> >> >>
> >> >>
> >> >> --
> >> >> Regards Ron de Bruin
> >> >> http://www.rondebruin.nl
> >> >>
> >> >>
> >> >> "CaraVanTea" <[email protected]> wrote in message
> > news:[email protected]...
> >> >> >I posted it to you a moment ago - hope it went through well.
> >> >> >
> >> >> > Thanks in advance for having a look at it.
> >> >> >
> >> >> > "Bob Phillips" a écrit :
> >> >> >
> >> >> >> I am happy to take a look. Note the spam filter in my addy which
> > needs to be
> >> >> >> removed - the nothere
> >> >> >>
> >> >> >> --
> >> >> >> HTH
> >> >> >>
> >> >> >> Bob Phillips
> >> >> >>
> >> >> >> "CaraVanTea" <[email protected]> wrote in message
> >> >> >> news:[email protected]...
> >> >> >> > Hi Arvi,
> >> >> >> >
> >> >> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could
> > send you
> >> >> >> > guys the file in question? (am for the first time on this
> > discussion
> >> >> >> forum)
> >> >> >> >
> >> >> >> >
> >> >> >> > "Arvi Laanemets" a écrit :
> >> >> >> >
> >> >> >> > > Hi
> >> >> >> > >
> >> >> >> > > Haven't you used Freeze Panes with column with data validation
> > as
> >> >> >> rightmost
> >> >> >> > > fixed one?
> >> >> >> > >
> >> >> >> > >
> >> >> >> > > --
> >> >> >> > > Arvi Laanemets
> >> >> >> > > ( My real mail address: arvil<at>tarkon.ee )
> >> >> >> > >
> >> >> >> > >
> >> >> >> > > "CaraVanTea" <[email protected]> wrote in
> > message
> >> >> >> > > news:[email protected]...
> >> >> >> > > > Hi,
> >> >> >> > > >
> >> >> >> > > > I'm very much used to working with the different possibilities
> > of the
> >> >> >> > > > Data-Validation feature and am pretty satisfied with it.
> > Nevertheless
> >> >> >> for
> >> >> >> > > > no
> >> >> >> > > > apparent reason sometimes the arrow indicating that there is a
> >> >> >> > > > dropdown-list
> >> >> >> > > > available disappears. Strange enough the parameters are yet
> > correct
> >> >> >> (eg.
> >> >> >> > > > the
> >> >> >> > > > zone determining the cells to appear in the list is still
> > correct).
> >> >> >> > > >
> >> >> >> > > > Has anyone an explanation/solution for this problem?
> >> >> >> > >
> >> >> >> > >
> >> >> >> > >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >
> >
>
>
>

Hi

See my question in your mail box

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


"CaraVanTea" <[email protected]> wrote in message news:[email protected]...
> Addendum
>
> Ron,
>
> There's actually another quite strange behaviour: If you doubleclick on the
> Column-Width (column A) an error report will be generated. If you open the
> restored file afterwards, the dropdown reappears.
>
> Nevertheless it doesn't give me the answer why it disappears in the first
> place....
>
> Good luck
>
> "Ron de Bruin" a écrit :
>
>> Hi Bob
>>
>> > never got it.
>> Ahaaa
>>
>>
>> Hi CaraVanTea
>>
>> You can send it to me also if you want.
>> I use a real mail address in this newsgroup.
>>
>> I will send it to Bob when I don't see the problem
>>
>>
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Bob Phillips" <[email protected]> wrote in message news:[email protected]...
>> > never got it.
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > "Ron de Bruin" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Yes that is correct.
>> >>
>> >> Have Bob reply to you when you send him the workbook?
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >> "CaraVanTea" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> > Hi Ron,
>> >> >
>> >> > The "Tools>Options>View" is on "Show all". Guess that's correct.
>> >> >
>> >> > "Ron de Bruin" a écrit :
>> >> >
>> >> >> Have you look in Tools>Options View
>> >> >> See the Objects line
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Regards Ron de Bruin
>> >> >> http://www.rondebruin.nl
>> >> >>
>> >> >>
>> >> >> "CaraVanTea" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> >> >I posted it to you a moment ago - hope it went through well.
>> >> >> >
>> >> >> > Thanks in advance for having a look at it.
>> >> >> >
>> >> >> > "Bob Phillips" a écrit :
>> >> >> >
>> >> >> >> I am happy to take a look. Note the spam filter in my addy which
>> > needs to be
>> >> >> >> removed - the nothere
>> >> >> >>
>> >> >> >> --
>> >> >> >> HTH
>> >> >> >>
>> >> >> >> Bob Phillips
>> >> >> >>
>> >> >> >> "CaraVanTea" <[email protected]> wrote in message
>> >> >> >> news:[email protected]...
>> >> >> >> > Hi Arvi,
>> >> >> >> >
>> >> >> >> > No, nor Freeze Panes nor Split Windows. Is there any way I could
>> > send you
>> >> >> >> > guys the file in question? (am for the first time on this
>> > discussion
>> >> >> >> forum)
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Arvi Laanemets" a écrit :
>> >> >> >> >
>> >> >> >> > > Hi
>> >> >> >> > >
>> >> >> >> > > Haven't you used Freeze Panes with column with data validation
>> > as
>> >> >> >> rightmost
>> >> >> >> > > fixed one?
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >> > > --
>> >> >> >> > > Arvi Laanemets
>> >> >> >> > > ( My real mail address: arvil<at>tarkon.ee )
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >> > > "CaraVanTea" <[email protected]> wrote in
>> > message
>> >> >> >> > > news:[email protected]...
>> >> >> >> > > > Hi,
>> >> >> >> > > >
>> >> >> >> > > > I'm very much used to working with the different possibilities
>> > of the
>> >> >> >> > > > Data-Validation feature and am pretty satisfied with it.
>> > Nevertheless
>> >> >> >> for
>> >> >> >> > > > no
>> >> >> >> > > > apparent reason sometimes the arrow indicating that there is a
>> >> >> >> > > > dropdown-list
>> >> >> >> > > > available disappears. Strange enough the parameters are yet
>> > correct
>> >> >> >> (eg.
>> >> >> >> > > > the
>> >> >> >> > > > zone determining the cells to appear in the list is still
>> > correct).
>> >> >> >> > > >
>> >> >> >> > > > Has anyone an explanation/solution for this problem?
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >
>> >
>>
>>
>>