+ Reply to Thread
Results 1 to 5 of 5

Macro to Click 'X' Close Button Dependent on Screen Resolution

  1. #1
    Forum Contributor
    Join Date
    05-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    682

    Macro to Click 'X' Close Button Dependent on Screen Resolution

    Hi, I wonder whether someone may be able to help me please.

    I'm not even sure whether this is possible, because after quite an amount of time researching this I've not found anything close to this, but is it possible to put together a VB script which captures and then clicks the 'X' close button on a window no matter what the screen resolution is?

    Many thanks and kind regards

    Chris

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Macro to Click 'X' Close Button Dependent on Screen Resolution

    Are you talking about Just with an excel book VBA or VB Script for any window?
    -If you think you are done, Start over - ELeGault

  3. #3
    Forum Contributor
    Join Date
    05-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    682

    Re: Macro to Click 'X' Close Button Dependent on Screen Resolution

    Hi @EleGault, thank you for coming back to me so quickly with this. It would be a VB script for any window.

    Many thanks and kind regards

    Chris

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Macro to Click 'X' Close Button Dependent on Screen Resolution

    While this is a source for Excel - I would actually venture out of VB and go with a batch file to kill known tasks that you expect to be open and wish to close. Simpler, and cleaner... Taskkill /IM ...

  5. #5
    Forum Contributor
    Join Date
    05-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    682

    Re: Macro to Click 'X' Close Button Dependent on Screen Resolution

    Hi @EleGault, thank you for this I'll look into it.

    Kind Regards

    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] close and open a Workbook with a macro button click
    By deano3141 in forum Excel General
    Replies: 3
    Last Post: 03-13-2014, 01:26 PM
  2. [SOLVED] Adjust screen resolution automatically to fit all screen sizes
    By Ace_XL in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 08:51 AM
  3. Macro to adjust zoom percentage depending on users screen resolution?
    By Smeddlesboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2011, 06:45 AM
  4. Close button when in full screen
    By sharkfoot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2006, 01:51 AM
  5. [SOLVED] Change Screen Resolution Macro
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2006, 01:30 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1