Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    12

    Unanswered: Run Macro to Quit

    Dear reader,

    How can I run a Macro to quit my program ?

    I created a button, and by clicking on it, it runs a macro that Opens a form (This form is like a exit screen. It has a picture and a "thank you, please come again" text) for 4 seconds and then it closes.

    I would like to run a macro to quit the whole program automatically after that 4 seconds. However, a msg box pops up saying,
    "The 'Quit' macro action cannot run with the specified 'Options' argument either when in disabled mode or when called from an embedded macro."

    Is there a way to solve this?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Best to avoid macros.

    Put this in the in the form close event in VBA:
    Code:
    Application.Quit

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •