By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

Delete a Worksheet

P: n/a
Hi,

How can I delete a worksheet in excel without the prompting window?

Thanks

Carlos Cruz
Nov 20 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
You need to use VBA, Access the WorkSheets collection and Call Delete method there.
<ca*********@algeco.pt> wrote in message news:O$**************@TK2MSFTNGP12.phx.gbl...

Hi,

How can I delete a worksheet in excel without the prompting window?

Thanks

Carlos Cruz
Nov 20 '05 #2

P: n/a
Hi Carlos,

Assuming that you just want to know about the prompt disabling, and not
about the deletion, you could give this a go.

oExcel = New Excel.Application
oExcel.DisplayAlerts = False

Or do you need to know about deleting as well?

Regards,
Fergus
Nov 20 '05 #3

P: n/a
<ca*********@algeco.pt> schrieb
Hi,

How can I delete a worksheet in excel without the prompting
window?


Using VB.NET?
--
Armin

Nov 20 '05 #4

P: n/a
Boring
Nov 20 '05 #5

P: n/a
Hi Nice Chap,

Hey, a nice bit of colour, too! ;-)

Regards,
Fergus
Nov 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.