Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-21-2012, 01:28 PM
Intruder Intruder is offline overcome user interaction Windows XP overcome user interaction Office 2007
Advanced Beginner
overcome user interaction
Join Date: Dec 2010
Posts: 56
Intruder is on a distinguished road
Default overcome user interaction

how can I overcome user interaction such as clicking OK or Cancel ?

Reason; in a VBA macro, I copy the Entry Table from the Global to my personal file, which needed to be overwritten... OK or cancel interaction needed
Reply With Quote
Old 12-24-2012, 02:00 PM
JulieS JulieS is offline overcome user interaction Windows 7 64bit overcome user interaction Office 2010 32bit
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough

The typical method is
Application.DisplayAlerts = False

as the first line under the Procedure name.

I hope this helps.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on userform and doc interaction icecode Word 3 08-01-2012 08:41 AM
Specific and no other interaction points? anevins PowerPoint 0 03-20-2011 11:37 AM
HELP For New USER ryalls3857 Outlook 0 09-29-2010 10:33 AM
User seeing other user's color categories MTFysherman Outlook 0 11-13-2008 04:36 PM
New Outlook User Chas F Outlook 1 08-31-2008 07:06 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:40 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft