PC Review


Reply
Thread Tools Rate Thread

Deleting Sheets - Without a prompt

 
 
=?Utf-8?B?TmljaG9sYXMgQg==?=
Guest
Posts: n/a
 
      16th Nov 2006
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

 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a
 
      16th Nov 2006
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
>

 
Reply With Quote
 
=?Utf-8?B?TmljaG9sYXMgQg==?=
Guest
Posts: n/a
 
      21st Nov 2006
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
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:00 PM.