Change between sheets with macro

  • Thread starter Thread starter greenfalcon
  • Start date Start date
G

greenfalcon

Here is my problem, i have a worksheet, and that worksheet has a macr
connected to a button pointing to another sheet labled "helpfile"

what i want to happen is when someone is on the helpfile sheet they ca
press a button named "return to last sheet" or something, when the
press it it takes them to the sheet they selected the helpfile from

for example the user path would be like this

user is on sheet, january 2004

Hit button labled "helpfile"

they are now on the sheet labled "helpfile"

They now click "last selected sheet"

user is on sheet. january 2004


Thanks for trying to help me.

Gree
 
Hi Green,
If you create a link you can use the web BACK key
(Alt+ArrowLeft) to return, you can install the
BACK and FORWARD web buttons on your toolbar.

The link can be from a macro (FollowHyperlink Method)
such as a doubleclick event macro invoked from anywhere
anywhere on the worksheet or from a button as you indicate
you already have with code.

For an example of various ways to implement your request see
my web page. I do not want this material to appear in ExcelForum
which messes up web searches by ripping off content posted to
newsgroups and making them web pages.
http://www.mvps.org/dmcritchie/excel/sheets.htm#followhyperlink

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Hi Green,
If you create a link you can use the web BACK key
(Alt+ArrowLeft) to return, you can install the
BACK and FORWARD web buttons on your toolbar.

The link can be from a macro (FollowHyperlink Method)
such as a doubleclick event macro invoked from anywhere
anywhere on the worksheet or from a button as you indicate
you already have with code.

For an example of various ways to implement your request see
my web page. I do not want this material to appear in ExcelForum
which messes up web searches by ripping off content posted to
newsgroups and making them web pages.
http://www.mvps.org/dmcritchie/excel/sheets.htm#followhyperlink

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top