dcsimg
Results 1 to 4 of 4

Thread: prevent prompting to user

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908

    prevent prompting to user

    when i open an excel file from vb....save file as...del some sheets.it will prompt the user to confirm delete..how do i stop this prompting?

  2. #2
    PowerPoster
    Join Date
    Aug 2001
    Location
    new jersey
    Posts
    2,904
    probably like this:

    xlApp.DisplayAlerts = False

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    does this means that the prompting default would be yes or no?

  4. #4
    PowerPoster i00's Avatar
    Join Date
    Mar 2002
    Location
    1/2 way accross the galaxy.. and then some
    Posts
    2,337
    this just deletes them w/o prompting

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width