View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
chat chat is offline
external usenet poster
 
Posts: 5
Default Button commands or hyperlinks

Thanks Pete, I thought about that too but I was really hoping I wouldn't have
to do that. Each page is a form that needs to be completed by the user and
I'm linking that to a help screen to explain what is expected on the form. I
was really trying to find a way that they could go right back to the form
they came from without multiple links.
Thanks again for you assistance.


"Pete_UK" wrote:

What I have done in the past is to have a Contents sheet which has
hyperlinks to each sheet, and then in each sheet I have a hyperlink
formula which takes you back to the Contents page - this avoids the
need for separate hyperlinks for Back-One-Sheet.

Hope this helps.

Pete

On Nov 5, 2:40 am, chat wrote:
I am creating a workbook and plan to have a help sheet located within the
workbook. I don't have any problem linking each sheet to the help sheet with
the use of a hyperlinked ? button. What I can't seem to do is creat a back
button that will take the user back to the last page they were on.
I can creat a back link but I can only set it to one page. If the user is on
a different page it won't work. Rather then create several buttons that go
back to each page, is there a way to creat a back button that will take you
back to the previous page no matter which page that was?

Thanks for any help you can give. I'm trying to self teach but sometimes I
just can't find the answer and I have to ask.