Results 1 to 2 of 2

Thread: Answering prompt boxes automatically with VBA

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 2007
    Posts
    17

    Answering prompt boxes automatically with VBA

    As in:

    ==============

    "Changes have been made to the document. Do you want to save?"

    [Yes] [No] [Cancel]

    ==============

    I believe VBA can just input the answer automatically so my program doesn't pause for such mundane questions. How do I accomplish this? I'm sure it must be basic to any VB programmer.

  2. #2
    INXSIVE Bruce Fox's Avatar
    Join Date
    Sep 2001
    Location
    Melbourne, Australia
    Posts
    7,429

    Re: Answering prompt boxes automatically with VBA

    You may find you can set the Alerts to False for that operation.

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