ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   validation combo boxes not working (https://www.excelbanter.com/excel-worksheet-functions/28349-validation-combo-boxes-not-working.html)

steve alcock

validation combo boxes not working
 
Hi Team,

My system crashed and as a result my validation combo boxes don't work, I
have tried :

copy / cut paste
in both existing and new cloumns

new list headings

all the usual stuff but still on this worksheet they refuse to work, anyone
any ideas how I cab restore them

thanks

steve



Peo Sjoblom

since you say you have combo boxes I assume you have some code associated
with them, make sure the crash didn't change the macro security to high, if
so you wouldn't even get a macro warning when you open the files

--
Regards,

Peo Sjoblom


"steve alcock" wrote in message
...
Hi Team,

My system crashed and as a result my validation combo boxes don't work, I
have tried :

copy / cut paste
in both existing and new cloumns

new list headings

all the usual stuff but still on this worksheet they refuse to work,
anyone
any ideas how I cab restore them

thanks

steve




Debra Dalgleish

Are objects visible? (ToolsOptions, View tab, Objects: Show All)

If that's not it, perhaps the worksheet was corrupted in the crash, and
you may have to copy everything to a new sheet.

steve alcock wrote:
My system crashed and as a result my validation combo boxes don't work, I
have tried :

copy / cut paste
in both existing and new cloumns

new list headings

all the usual stuff but still on this worksheet they refuse to work, anyone
any ideas how I cab restore them


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



All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com