On Tue, 1 Feb 2011 06:07:51 -0800 (PST), Don Guillett
wrote:

On Feb 1, 4:07*am, StargateFan
wrote:
Rather than make various different buttons on my toolbar, it would be
much easier for users to press one button and toggle navigating to 2
specific and going back to A2 at last toggle. *Can this be done?

i.e., from startpoint (whatever it is) go to D2
from D2 to G2 and then each time pressing navigation goes backwards:
G2 to D2
D2 to A2

Thanks! *:oD

Do you just want to goto these cells or is it fair to assume that you
want to make an entry in each?? Still confusing.

Oh, yes. User will need to enter data into cells after navigating to.
Honestly, though, I had no idea it would be this tough.

I've gone back to re-assess and re-wrote things. By a very strange
coincidence, the cells are evenly spaced apart. So I hope it's okay
and didn't mean to cause a ruckus <g, but have decided to not go into
something that may still be beyond me to do. Using variables and
storing data reminds me of the headaches I've had in writing simple
databases. So thought I'd save the headaches all around.

Ultimately, "ActiveCell.Offset(0, -3).Select" and
"ActiveCell.Offset(0, 3).Select" work perfectly fine in my toolbar.
And FaceIDs have 2 great buttons of 155 and 156 so that works well.
And it does the job.

Thanks everyone. Appreciate the help.

******************

p.s., before closing this issue, I have a question. When I first went
on Office 2007 (which I hate, btw ... sorry), I was told all the
floating toolbars on our spreadsheets would never work. And they
don't. There was _some_ help for the static custom toolbars but the
results are grossly inadequate.

Will there ever be a way to get back complete functionality with our
older Office files? The ribbon doesn't come even close to what my
custom toolbars do and the floating toolbars just can't be beat in the
files that I have them on. Thx. Just curious if any strides have
been made to bridge the new with the more efficient (to me) old.