+ Reply to Thread
Results 1 to 2 of 2

Is there any kind of 'Back' button in excel?

  1. #1
    Forum Contributor
    Join Date
    12-07-2013
    Location
    Staten Island, New York
    MS-Off Ver
    Excel 2010
    Posts
    106

    Is there any kind of 'Back' button in excel?

    Hi everyone. I just wanted to know if there's a way to go back to the last place before the current one.

    So if I am on sheet 10, cell ZZ4856 and go to sheet 1, cell A1...

    is there an easy way to get back to the last cell previously (sheet 10, cell ZZ4856)?

    If there's nothing built in, is it possible to set something like this up?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,454

    Re: Is there any kind of 'Back' button in excel?

    You could probably do it with a Workbook Selection Change event handler. You could, for example, store the sheet and the cell in a two dimensional array every time you select a cell. You'd have to decide how big a "stack" you want to maintain.

    I suspect it's doable but it's not something I'd consider. Running macros tends to junk the Undo Stack so it could have wide reaching impacts.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. How to when deselecting my radio button list and my excel goes back to original ?
    By achill3s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2011, 05:49 AM
  2. Replies: 0
    Last Post: 10-01-2010, 08:16 AM
  3. Replies: 2
    Last Post: 02-09-2009, 05:07 AM
  4. [SOLVED] How can you close a window with the back button in excel
    By Holly Williams in forum Excel General
    Replies: 0
    Last Post: 09-20-2005, 09:05 AM
  5. Button that creates a back up in Excel
    By petros89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2005, 04:05 PM
  6. how to take the back up of excel sheet on floppy automatically through a button
    By u_tina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2005, 01:23 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