Hyperlink Back
you have the correct code module
"Application.Goto" reverses a goto if you will, so long as there was one,
otherwise it errors
to test:
so paste the code. select a cell on the sheet. hit F5 and use the goto to go
to another cell, then run the code -- you'll see the original cell is now
selected
Sub goback()
on error resume next
Application.Goto
on error goto 0
End Sub
"CAM" wrote in message
...
OK.......I've never created a macro before but........I've started the
process and I have a Module1 (Code) window up that has "(General)" to the
top
left and "goBack" in the top right. Beneath is the space where the actual
application run code would be written........Right?!?!?
What do I put here? What you wrote, below?
Sub goback()
Application.Goto
End Sub
Shouldn't I put something else like in the parens?
This is fun!
CAM
"Gary''s Student" wrote:
Plop any kind of button, or Picture, or ClipArt on the sheet and assign
this
macro to it:
Sub goback()
Application.Goto
End Sub
This is the VBA equivalent to ALT-BACKARROW.
Alternatively, you can programmatically:
View Toolbars Web
There is a nice backarrow on this toolbar
--
Gary''s Student - gsnu200820
"Hyperlinking Back" wrote:
Yes I know that keyboard short cut but I need to make this braindamaged
simple and obvious for others. So a button or hyperlink is what I
envision.
"Gary''s Student" wrote:
ALT-BACKARROW
--
Gary''s Student - gsnu200820
|