Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel DropDown List
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00860060
Message ID:
00860367
Vues:
17
Terry,
Thanks for looking, I did just figure out something here though. The sheet was protected. Not the cell I was working on though, a totally different cell. But having the protection enabled, you can't add any of the validation stuff to Excel. I just turn of the validation before the code runs, then turn it back on afterwards, it adds just fine.
*run this line after everything is added
*activate the protection
.ActiveSheet.PROTECT( .T., .T., .T. )
*DrawingObjects:=True, Contents:=True, Scenarios:=True
Thanks,
jfh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform