Macro Setting

's Computer Specifications

I am setting up a macro and in it the is a "make a table" query that
would require the user to click on "yes". Is there a way that popups
don't appear and yes is the default?

's Computer Specifications

Preceed it with SetWarnings to No, then the query, and follow with
SetWarnings to Yes.
--
Build a little, test a little.

"H" wrote:

> I am setting up a macro and in it the is a "make a table" query that
> would require the user to click on "yes". Is there a way that popups
> don't appear and yes is the default?
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Button looses Macro setting when running Macro	Dule	Microsoft Excel Programming	1	7th Oct 2009 04:52 AM
setting OnAction macro names for form controls from a VBA macro	jon	Microsoft Excel Programming	5	10th Mar 2004 07:34 PM
Sending email via macro- setting the importance setting.	Julian Milano	Microsoft Excel Programming	1	20th Jan 2004 11:15 PM
office 2003 losing very high security macro setting + other setting	=?Utf-8?B?c3AyMDM=?=	Microsoft Word Document Management	0	3rd Dec 2003 03:41 PM
Start Macro / Stop Macro / Restart Macro	Pete	Microsoft Excel Programming	2	21st Nov 2003 06:04 PM