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 |
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 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com