Results 1 to 3 of 3

Thread: delete sheet in excel with vba/vb without being prompted?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    Does anyone know how to delete a sheet w/o being prompted with a "are you sure you want to delete this sheet, etc" in code of course?????????

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482
    Code:
    Application.DisplayAlerts = False
    '  Do what you need here...
    Application.DisplayAlerts = True

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    exsellent -- 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
  •  



Click Here to Expand Forum to Full Width