View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joshua @ UDA Joshua @ UDA is offline
external usenet poster
 
Posts: 1
Default Data Validation Drop-Down Will Not Appear

Hello,

I have an Excel spreadsheet that has been customized using VBA to perform a
variety of additional functions. There are several worksheets and each
worksheet has cells which utilize drop-down validation. Of the thirteen or
fourteen worksheets, two of them will not display the drop-down. Validation
still works, but the drop down itself will not appear. I've researched this
enough to know that my Drop Down Shape may have been removed from this
worksheet. I know that I could copy the cells into another worksheet, but I
am curious if there is a way to reinsert the necessary drop down shape into
the corrupted worksheet. Any help is appreciated, thanks.

Joshua