Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The SetOption method

Status
Not open for further replies.

Bristowj

Programmer
Joined
Jul 4, 2001
Messages
7
Location
GB
Can anyone tell me how to use the SetOption method in VBA to turn off the Confirm changes checkboxes located in?

Tools -> Options -> edit/find tab -> confirm boxes

there are three options I need to turn off.

Record Changes
Document Deletions
Action Queries

Thanks
%-(
 
With Application
.SetOption "Confirm Record Changes", 0
.SetOption "Confirm Document Deletions", 0
.SetOption "Confirm Action Queries", 0
End With

IS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top