Main Area and Open Discussion > General Software Discussion

ctrl + tab (first in, first out history) for excel sheets?

<< < (4/7) > >>

Perry Mowbray:
You are right  :D
 CTRL+ALT+TAB is a contorsion for me.
I'll try to change it on the code.-urlwolf (April 02, 2007, 07:33 AM)
--- End quote ---

No, don't worry, try the attached.

The penny's finally dropped that you don't want to cycle through the WorkSheets, so I've removed it  ;)

The Add-In is now set:

* CNTL+TAB goes back in the view history

* CNTL+SHIFT+TAB goes forward
I've also added a function that I find very handy: FollowReference. I don't know about you, but my sheets tend to reference lots of other cells. FollowReference will activate the referenced cell (if it can figure it out) or display the Precendants for you to choose.

I've also added buttons to the tool bar.

I've just a bit of a play, and everything seems to work without falling apart gracelessly  :)

Most of the settings are at the top of the WorkHistory Module: HotKey combinations, number of "views" to remember.

Then, how do I make this change "permanent" (i.e., opening with excel everytime)?-urlwolf (April 02, 2007, 07:33 AM)
--- End quote ---

You just put it into your Excel Add-In directory, the location of which depends what version of Windows you are running:
For Excel 2007 for the PC, the default path to this folder is for Windows XP, and probably Vista:

--- ---C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns
For Excel 2003, XP and 2000 for the PC, the default path to this folder is for Windows 2000 or Windows XP:

--- ---C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns
or, if user profiles are used on your computer:

--- ---C:\Windows\Profiles\UserName\Application Data\Microsoft\AddIns
or, for older Windows operating systems:

--- ---C:\Windows\Application Data\Microsoft\AddIns
For Excel 97 for the PC, the default path is:

--- ---C:\Program Files\Microsoft Office\Office\Library
Hope that helps, let me know if things don't work,
Perry

Perry Mowbray:
example. We have tabs A-C, and we click A, B, C. We are in C now, doing some work. I want to go back to B, so I hit ctrl tab. check some data, then I want to go back to C, and hit ctrl tab (as in windows alt tab). The current code takes me to A, not to C.-urlwolf (April 02, 2007, 07:44 AM)
--- End quote ---

You're right, it's more like a Browser History.

So you browse from A > B > C,
press GoBack = B
press GoForward = C
press GoBack = B
press GoBack = A
press GoForward = B

Hmm, that's what made sense at the time  :-\

urlwolf:
Thanks, I'll make it permanent!
So I reckon you prefer the browser history paradigm, right?
I still like the "win alt tab" better.
Is this easy to implement?

Testing now your very handy FollowReference...

urlwolf:
In fact, mostly any program that has tabs implements this kind of 'alt tab' behavior. Excel does have tabs, although they cannot be relocated.

I wonder why M$ didn't think of this before... weird. My browser works that way, my editor works that way... why do we have to do contorsions to get this basic functionality in excel?

Perry Mowbray:
Is this easy to implement?
-urlwolf (April 02, 2007, 08:38 AM)
--- End quote ---

I'm working on it... It's getting there...

Navigation

[0] Message Index

[#] Next page

[*] Previous page