LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default How to bypass "Enter Parameter Value" via macros

I have a simple macro to Generate a Report that I will use for several
databases; however, I have certain datafields that are present in some
databases and not others -- which is okay. My issue is when executing
the report macro on a database that does not have these datafields, I
get a separate popup window ("Enter Parameter Value"). If I don't enter
anything and manually click "Okay", the macro will complete the
remaining steps and generate the report.

Question - What can I do to have the Macro click "Okay" and complete
the remaining steps. My goal is to bypass the manual click of "Okay".

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! [email protected] Excel Discussion (Misc queries) 3 January 5th 07 02:18 PM
Make "Edit" mode default, rather than "Enter"? Greg Boettcher Excel Discussion (Misc queries) 1 July 27th 06 01:46 AM
can I bypass "Windows has encountered a problem" fredashe Excel Discussion (Misc queries) 0 April 15th 06 04:53 PM
How to "bypass" run-time error '91'???? Jeff[_43_] Excel Programming 1 December 13th 04 08:42 PM
Bypass "DISable Macros" Chip R. Excel Programming 2 August 6th 04 06:23 PM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"