Deleting Sheets - Without a prompt

's Computer Specifications

Anyone know if its possible to switch off prompting for confirmation when a
macro wants to delete a sheet ?

I've tried using sendkeys with " " to click the default button but that
doesn't seem to work.

Thanks, Nick

's Computer Specifications

Give this a whirl...

Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = true

--
HTH...

Jim Thomlinson

"Nicholas B" wrote:

> Anyone know if its possible to switch off prompting for confirmation when a
> macro wants to delete a sheet ?
>
> I've tried using sendkeys with " " to click the default button but that
> doesn't seem to work.
>
> Thanks, Nick
>

's Computer Specifications

Thanks Jim

How simple !

"Jim Thomlinson" wrote:

> Give this a whirl...
>
> Application.DisplayAlerts = False
> Sheets("Sheet1").Delete
> Application.DisplayAlerts = true
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Nicholas B" wrote:
>
> > Anyone know if its possible to switch off prompting for confirmation when a
> > macro wants to delete a sheet ?
> >
> > I've tried using sendkeys with " " to click the default button but that
> > doesn't seem to work.
> >
> > Thanks, Nick
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linked Sheets 'Startup Prompt' doesn't work	Andy	Microsoft Excel Misc	0	11th Jan 2008 01:40 PM
Re: Deleting Custom Views when Deleting Sheets	NickHK	Microsoft Excel Programming	0	28th Mar 2007 06:11 AM
Protect sheets w/o user password prompt	hotherps	Microsoft Excel Programming	6	24th Nov 2004 04:10 PM
Delete Sheets - OK prompt	Jesse Braswell	Microsoft Excel Discussion	1	9th Mar 2004 04:09 PM
Deleting sheets removing/turning off the xl prompt	EMMA	Microsoft Excel Programming	2	2nd Mar 2004 11:55 AM