Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YIKES! All Validation functionality DISAPPEARED!
Help Please!
I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still there.. but the arrows and menus within the cells disappeared! Not only that, but I can't create a validation list anywhere on this sheet! HELP! Whasssswrong!!!? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YIKES! All Validation functionality DISAPPEARED!
hi, Stilla !
I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still there... but the arrows and menus within the cells disappeared! Not only that, but I can't create a validation list anywhere on this sheet! ... and/or... tools options view [tab] objects [section] hide all [see if checked-on] and/or... [somehow like a macro] deleted shapes [validation dropdown incuded] on 'that' worksheet [so...] and/or... [somehow] 'that' worksheet has corrupted [maybe] you will need to re-create 'the worksheet' [and delete corrupted one] hth, hector. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YIKES! All Validation functionality DISAPPEARED!
Hi Stilla,
I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still there.. but the arrows and menus within the cells disappeared! Not only that, but I can't create a validation list anywhere on this sheet! The last frase ("can't create a validation list ANYWHERE on this sheet") makes me doubt a bit, but what you describe may happen in Excel97 if your validation cell happens to be in the frozen area when menu WindowsFreeze Panes is used. Regards, KL |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YIKES! All Validation functionality DISAPPEARED!
Hi Stilla
I have seen this problem a few times the last months and can only reproduce it when I use a macro that delete all shapes on the sheet. Have you used VBA on that sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Stilla" wrote in message ... Help Please! I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still there.. but the arrows and menus within the cells disappeared! Not only that, but I can't create a validation list anywhere on this sheet! HELP! Whasssswrong!!!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TWO QUESTIONS: Validation & Spacing...PLEASE HELP | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |