+ Reply to Thread
Results 1 to 3 of 3

delete without being prompted macro

  1. #1
    Forum Contributor
    Join Date
    03-23-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    153

    delete without being prompted macro

    hi
    ive used the record macro facility and came up with this code
    Please Login or Register  to view this content.
    i know this is probably a lot longer than it needs to be but it works.

    the problem ive got is that i get this message come up for e very single sheet and dont want to be prompted
    "data may exist in the sheet (s) selected for deletion. to permanantly delete the date press delete."

    if anyone could help simply this code and the prompting problem it would be much appreciated.

    kind regards
    Last edited by sdts; 04-04-2010 at 10:17 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,438

    Re: delete without being prompted macro

    Use the following to suppress the prompt.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    03-23-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    153

    Re: delete without being prompted macro

    thanks andy

+ 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