Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    130

    Unanswered: Using VBA turn off Tool Options Edit/Find Confirming

    Is there a way in VBA to turn off the default values in Tools Options Edit/Find Confirm?
    thanks,
    Winston

  2. #2
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    441
    All the options available thru Tools | Options can be altered thru VBA.

    For instance, the default "Record Changes" option for the "Confirm", can be altered either by manually unselecting, or using the setoption method of the application object

    application.setoption "Confirm Record Changes",0

    Where
    False: 0
    True: -1

    It is probably advicable to fetch the current setting prior to altering the settings, with the application.getoption method, and reset when closing the app?

    Here's a reference
    http://msdn.microsoft.com/library/de...isualBasic.asp
    Roy-Vidar

Posting Permissions

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