Consulting

Results 1 to 2 of 2

Thread: Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window

  1. #1

    Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window

    I created a macro that imports data from a database. In the macro, I delete the page that the data was on, and each time get a popup window that reads, "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete."

    Is there a way to permanently delete the data in the code? (If I use 'clear contents" i get the same popup.)

    Thank you

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    You really should post the code your using.....
    You might try this:
    [VBA]Application.DisplayAlerts = False
    'your code
    'Don't forget to reset application.DisplayAlerts to True
    Application.DisplayAlerts = True[/VBA]
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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