I have introduced data validation and dynamic ranges to one of my co-workers.
All data validation drop down boxes were working fine when I sent them the
workbook. Now the in cell drop down boxes are not being show even though this
setting is enabled. Has anyone else experienced this problem. Help is greatly
appreciated

The only time i have seen something similar happening was when deleting
Shapes on a worksheet. Eg:
dim s as shape
for each s in activesheet.shapes
s.delete
next
This would delete the drop-down from either the filters or the data
validation... cannot remember. Also after this action, the drop down were not
recoverable, and i would have to recreate the sheet.
To prevent this from happening, only specific shape-type had to be deleted:
dim s as shape
for each s in activesheet.shapes
if s.type = ... then
s.delete
end if
next

Maybe someone else will have a clearer idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com

No shapes were deleted via vba... but thats good to know. Any other ideas,
there is about 15 data validations w/ drop down boxes and not a one has the
drop down box visible. Very frustrating...

"sebastienm" wrote:

The only time i have seen something similar happening was when deleting
Shapes on a worksheet. Eg:
dim s as shape
for each s in activesheet.shapes
s.delete
next
This would delete the drop-down from either the filters or the data
validation... cannot remember. Also after this action, the drop down were not
recoverable, and i would have to recreate the sheet.
To prevent this from happening, only specific shape-type had to be deleted:
dim s as shape
for each s in activesheet.shapes
if s.type = ... then
s.delete
end if
next

Maybe someone else will have a clearer idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com

It you go into tools=Options=View and under "objects" you select the
rightmost radio button (Hide all), I can reproduce this behavior.

--
Regards,
Tom Ogilvy


"James W." wrote in message
...
No shapes were deleted via vba... but thats good to know. Any other
ideas,
there is about 15 data validations w/ drop down boxes and not a one has
the
drop down box visible. Very frustrating...

"sebastienm" wrote:

The only time i have seen something similar happening was when deleting
Shapes on a worksheet. Eg:
dim s as shape
for each s in activesheet.shapes
s.delete
next
This would delete the drop-down from either the filters or the data
validation... cannot remember. Also after this action, the drop down
were not
recoverable, and i would have to recreate the sheet.
To prevent this from happening, only specific shape-type had to be
deleted:
dim s as shape
for each s in activesheet.shapes
if s.type = ... then
s.delete
end if
next

Maybe someone else will have a clearer idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com

Tom,
I toggled back and forth between these settings but still no drop down
showing up. Any other suggestions...

"Tom Ogilvy" wrote:

It you go into tools=Options=View and under "objects" you select the
rightmost radio button (Hide all), I can reproduce this behavior.

--
Regards,
Tom Ogilvy


"James W." wrote in message
...
No shapes were deleted via vba... but thats good to know. Any other
ideas,
there is about 15 data validations w/ drop down boxes and not a one has
the
drop down box visible. Very frustrating...

"sebastienm" wrote:

The only time i have seen something similar happening was when deleting
Shapes on a worksheet. Eg:
dim s as shape
for each s in activesheet.shapes
s.delete
next
This would delete the drop-down from either the filters or the data
validation... cannot remember. Also after this action, the drop down
were not
recoverable, and i would have to recreate the sheet.
To prevent this from happening, only specific shape-type had to be
deleted:
dim s as shape
for each s in activesheet.shapes
if s.type = ... then
s.delete
end if
next

Maybe someone else will have a clearer idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com

If you say the option in the Validation dialog is to show the dropdown, then
I would lean toward the validation being deleted particularly if you have
macros in the workbook - a possibility that one is writing where it
shouldn't.

If the validation is being enforced, but the dropdown is not showing, then I
don't have another good guess.

--
Regards,
Tom Ogilvy

"James W." wrote in message
...
Tom,
I toggled back and forth between these settings but still no drop down
showing up. Any other suggestions...

"Tom Ogilvy" wrote:

It you go into tools=Options=View and under "objects" you select the
rightmost radio button (Hide all), I can reproduce this behavior.

--
Regards,
Tom Ogilvy


"James W." wrote in message
...
No shapes were deleted via vba... but thats good to know. Any other
ideas,
there is about 15 data validations w/ drop down boxes and not a one
has
the
drop down box visible. Very frustrating...

"sebastienm" wrote:

The only time i have seen something similar happening was when
deleting
Shapes on a worksheet. Eg:
dim s as shape
for each s in activesheet.shapes
s.delete
next
This would delete the drop-down from either the filters or the data
validation... cannot remember. Also after this action, the drop down
were not
recoverable, and i would have to recreate the sheet.
To prevent this from happening, only specific shape-type had to be
deleted:
dim s as shape
for each s in activesheet.shapes
if s.type = ... then
s.delete
end if
next

Maybe someone else will have a clearer idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com

Sorry no idea, just a few questions:
- do the validations shows up on your computer after the user gives you the
book back?
-on your user's computer
1- In that same sheet, can you add new Data Validation with dorpdowns
showing?
2- In that same sheet, can you see the dropdowns of the Auto-Filter (menu
Data Filter AutoFIlter) applied to a list.
3- What about 1 & 2 on another sheet from the same book?
4- What about 1 & 2 in another book (after having opened the book that
fails or in a new excel session)?

--
Regards,
Sébastien
<http://www.ondemandanalysis.com