General information
Category:
COM/DCOM and OLE Automation
Title:
Answer Excel prompt in code
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only