+ Reply to Thread
Results 1 to 4 of 4

Stop messages appearing during macro

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-13-2006
    Location
    London
    Posts
    102

    Stop messages appearing during macro

    Hello all,

    This should be simple - I've done this before, but clean forgotten how!

    I have a macro that deletes a worksheet, but I want the macro to delete it without asking the user to confirm. How do I supress the message?

    Thanks.

  2. #2
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    You can use this and it will take the default action...

    Application.DisplayAlerts = False

  3. #3
    Forum Contributor
    Join Date
    04-13-2006
    Location
    London
    Posts
    102
    It's OK, I've remembered.

    Application.DisplayAlerts = False

  4. #4
    Forum Contributor
    Join Date
    04-13-2006
    Location
    London
    Posts
    102

    Talking

    Thanks Stuie, I remembered just before you posted. My old grey matter is a bit slower these days...!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1