| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to build a forward/back range finder
Is it possible to build a "stack" that remembers the last 5 (or whatever)
sheets and ranges, so that with key strokes the user can switct back to the previous sheet and selected range on that sheet, the sheet and selected range before that, and so on for five steps or so backward. Plus, once in the stack the user could reverse course and go to the Next sheet/selected range. John Wirt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to build a forward/back range finder
Not only possible, but already done by Jan Karel Pieterse.
http://www.jkp-ads.com/Download.htm look for: GoBack.Zip John Wirt wrote: Is it possible to build a "stack" that remembers the last 5 (or whatever) sheets and ranges, so that with key strokes the user can switct back to the previous sheet and selected range on that sheet, the sheet and selected range before that, and so on for five steps or so backward. Plus, once in the stack the user could reverse course and go to the Next sheet/selected range. John Wirt -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to use the back/forward buttons in the OPEN menu | Excel Discussion (Misc queries) | |||
| Macro for forward and back button | Excel Discussion (Misc queries) | |||
| What is the range finder and how do you use it? | Excel Discussion (Misc queries) | |||
| Web-type Back and Forward navigation between Excel worksheets | Excel Worksheet Functions | |||
| forward and back buttons in EXCEL | Excel Programming | |||
![John Wirt[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
