Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 24th, 2004, 08:34 AM
Authorized User
 
Join Date: Sep 2003
Location: Ipswich UK, , United Kingdom.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to MattLeek
Default Delete Without Prompt

Hi,
  In a Spreadsheet i'm doing, i want a sheet to be deleted but i don't want there to be a prompt. Is there a way to remove the page without it asking if you're sure you want to?

Thanks

Matthew Leek
__________________
Thanks,
Matthew
  #2 (permalink)  
Old March 24th, 2004, 08:41 AM
Registered User
 
Join Date: Sep 2003
Location: Guildford, Surrrey, United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to RogerWaters
Default

The answer I think is to add the following line in the VB

Application.alerting = false

but remember to set set it back to true at the end of the macro

Regards
Roger

Roger Waters
  #3 (permalink)  
Old March 24th, 2004, 08:45 AM
Registered User
 
Join Date: Sep 2003
Location: Guildford, Surrrey, United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to RogerWaters
Default

sorry mis typed should be

Application.DisplayAlerts = False


Roger Waters
  #4 (permalink)  
Old March 24th, 2004, 10:04 AM
Authorized User
 
Join Date: Sep 2003
Location: Ipswich UK, , United Kingdom.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to MattLeek
Default

Thanks for that it really helps!:)

Matthew Leek


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to delete file System.IO.Delete error maricar C# 13 March 14th, 2014 06:50 AM
php/mysql delete button and delete query dungey PHP Databases 17 April 11th, 2009 12:24 PM
Prompt to Save arholly Access 13 December 18th, 2006 06:32 PM
how to delete a row when click delete hyperlink naveenkumarg1 Pro JSP 1 August 16th, 2004 01:29 AM
CH12 p 404 delete prompt lanita BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 5 July 5th, 2004 05:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.