ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking to pages within a workbook? (https://www.excelbanter.com/excel-worksheet-functions/222012-linking-pages-within-workbook.html)

R. Ford

Linking to pages within a workbook?
 
Me again,

I know how to create the hyperlinks themselves when I'm on the computer I
created the Workbook.

How do I make the links so someone else on our network can also click the
links?

For instance I have a master log sheet as the first page and then that log
is linked to 15 different customers on different sheets for a more detailed
breakdown by customer.

How do I make a link on the first sheet that will work from any computer in
the office?

Thanks in advance,
Ryan F.



Shane Devenshire[_2_]

Linking to pages within a workbook?
 
Hi,

If they are links in the current workbook they will work on any machine.
You should create them by press Ctrl+K, choosing Place in this Document....

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"R. Ford" wrote:

Me again,

I know how to create the hyperlinks themselves when I'm on the computer I
created the Workbook.

How do I make the links so someone else on our network can also click the
links?

For instance I have a master log sheet as the first page and then that log
is linked to 15 different customers on different sheets for a more detailed
breakdown by customer.

How do I make a link on the first sheet that will work from any computer in
the office?

Thanks in advance,
Ryan F.



R. Ford

Linking to pages within a workbook?
 
So there's no way to have the links just in the document itself... so if you
click a link on the main page it will take me to Sheet 2? Obviously I have
done this already and it works on the computer I work on.

There is no way to make it work for anyone who opens the document?

"Shane Devenshire" wrote:

Hi,

If they are links in the current workbook they will work on any machine.
You should create them by press Ctrl+K, choosing Place in this Document....

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"R. Ford" wrote:

Me again,

I know how to create the hyperlinks themselves when I'm on the computer I
created the Workbook.

How do I make the links so someone else on our network can also click the
links?

For instance I have a master log sheet as the first page and then that log
is linked to 15 different customers on different sheets for a more detailed
breakdown by customer.

How do I make a link on the first sheet that will work from any computer in
the office?

Thanks in advance,
Ryan F.




All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com