Consulting

Results 1 to 3 of 3

Thread: Deleting a sheet without a prompt

  1. #1

    Cool Deleting a sheet without a prompt

    Hi,

    I'm using the below code as part of a macro to delete a sheet, however, the prompt to confirm sheet deletion appears. Is there anyway to avoid this and just delete the sheet??


    Windows("Combined Form 6 Template macro2.xls").Activate
        ActiveWindow.Close
    Thanks,
    Simon

  2. #2
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    you can turn these messages off with

    Application.DisplayAlerts = False
    But don't forget to set this back to True when you're done
    K :-)

  3. #3
    That's great, thanks!

Posting Permissions

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