Results 1 to 3 of 3

Thread: Deleting Excel Sheets without User intervention

  1. Aug 24th, 2001, 06:30 AM #1
    PeerBr
    PeerBr is offline

    Thread Starter
    Lively Member
    Join Date
    Apr 2001
    Location
    just as global as it gets
    Posts
    71

    Question Deleting Excel Sheets without User intervention

    Hey!

    I am writing a macro that uses one sheet as an output sheet. If I run this macro, it clears the existing output, kills all sheets except the first one (which contains the macro) and creates it from the draft.

    The thing is, the people I work for would flip if they see the macro deleting anything , even what the very same macro created. So I don't want the user to be asked if there is a sheet to be deleted. I just want to kick it, and it's my right, I created it
    The PC can't replace your life...
    ...but you can get a great break with it

    VB6, (D)HTML, JavaScript, TI-85
    German, English, Portuguese, Spanish, French & a bit of latin
    Reply With Quote Reply With Quote
  2. Aug 24th, 2001, 06:37 AM #2
    InvisibleDuncan
    InvisibleDuncan is offline
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 2001
    Location
    Eating jam.
    Posts
    819
    VB Code:
    1. Excel.Application.DisplayAlerts = False
    Make sure you set it back to true at the end of your procedure, or there'll be tears...
    Indecisiveness is the key to flexibility.

    www.mangojacks.com
    Reply With Quote Reply With Quote
  3. Aug 24th, 2001, 06:43 AM #3
    PeerBr
    PeerBr is offline

    Thread Starter
    Lively Member
    Join Date
    Apr 2001
    Location
    just as global as it gets
    Posts
    71

    Thumbs up



    Thanks, Duncan!
    The PC can't replace your life...
    ...but you can get a great break with it

    VB6, (D)HTML, JavaScript, TI-85
    German, English, Portuguese, Spanish, French & a bit of latin
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width