Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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: 59
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
  #2  
Old 12-24-2012, 02:00 PM
JulieS JulieS is offline overcome user interaction Windows 7 64bit overcome user interaction Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The typical method is
Application.DisplayAlerts = False

as the first line under the Procedure name.

I hope this helps.
Reply With Quote
Reply

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

All times are GMT -7. The time now is 06:03 PM.


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