Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Answer Excel prompt in code
Versions des environnements
Hi All,
I've created a program that opens an existing spreadsheet (basically a blank form), copies the worksheet and names the copy. The program will continue to add worksheets until the user has created all of their forms. THEN, I want to delete the "master" (blank) worksheet. I have the code correct for all of that, but I get this annoying little prompt...
Microsoft Excel
The selected sheet(s) will be permanently deleted.
-To delete the selected sheets, click OK
-To cancel the deletion, click Cancel
OK CANCEL
Can I respond to this (or just get rid of it) with code?
Thanks,
Martha
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement