+ Reply to Thread
Results 1 to 6 of 6

force to press button before leave a sheet

  1. 12-24-2014, 02:18 PM #1
    anicolash
    anicolash is offline
    Registered User
    Join Date
    12-24-2014
    Location
    NY
    MS-Off Ver
    2010
    Posts
    4

    force to press button before leave a sheet

    Hi!

    I need to create a macro that force you to press a button before you leave the sheet. Is it possible?
    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 12-24-2014, 02:32 PM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: force to press button before leave a sheet


    Hi !

    Maybe using Worksheet_Deactivate event …
    Reply With QuoteRegister To Reply
  3. 12-24-2014, 02:42 PM #3
    anicolash
    anicolash is offline
    Registered User
    Join Date
    12-24-2014
    Location
    NY
    MS-Off Ver
    2010
    Posts
    4

    Re: force to press button before leave a sheet

    I have already tried with that command and it is not possible, error
    Reply With QuoteRegister To Reply
  4. 12-24-2014, 02:44 PM #4
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: force to press button before leave a sheet



    Error just means a bad code, no that is not possible !
    Reply With QuoteRegister To Reply
  5. 12-24-2014, 02:46 PM #5
    anicolash
    anicolash is offline
    Registered User
    Join Date
    12-24-2014
    Location
    NY
    MS-Off Ver
    2010
    Posts
    4

    Re: force to press button before leave a sheet

    You have a point!
    Reply With QuoteRegister To Reply
  6. 12-24-2014, 03:00 PM #6
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool See a good code ! 


    Please Login or Register  to view this content.
    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to add the press effect of a button?
    By TheOllie in forum Excel General
    Replies: 16
    Last Post: 06-07-2014, 05:29 AM
  2. Force user to enable macros, only work if press save
    By Blokeman in forum Excel General
    Replies: 0
    Last Post: 03-09-2013, 10:25 PM
  3. Press button to open form for data entry and then send matching data to another sheet
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-19-2009, 11:34 AM
  4. [SOLVED] Button to set colour of selected cells & then force sheet calculat
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2005, 08:00 AM
  5. [SOLVED] how do you force the cell to leave the data as you type it?
    By Amanda in forum Excel General
    Replies: 2
    Last Post: 07-20-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1