ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Deactivate tabs to click (https://www.excelbanter.com/excel-worksheet-functions/6977-deactivate-tabs-click.html)

DrillerThriller

Deactivate tabs to click
 
Hi,
I would like people to enter a workbook on Sheet1 but have
to use a hyperlink in a cell to go to Sheet2 and on Sheet2
use a cell hyperlink in order to go to Sheet3. (Disable
tab hoping.)
Is this possible in Excel? (using 2003)

Thanks


Don Guillett

if you must

toolsoptionsviewsheet tabs

--
Don Guillett
SalesAid Software

"DrillerThriller" wrote in message
...
Hi,
I would like people to enter a workbook on Sheet1 but have
to use a hyperlink in a cell to go to Sheet2 and on Sheet2
use a cell hyperlink in order to go to Sheet3. (Disable
tab hoping.)
Is this possible in Excel? (using 2003)

Thanks




DrillerThriller

Thank you that worked fine. I thought some huge macro
would be needed!
It's for testing so what is done is done on the other
sheets and Sheet3 is not linked.

-----Original Message-----
if you must

toolsoptionsviewsheet tabs

--
Don Guillett
SalesAid Software

"DrillerThriller"

wrote in message
...
Hi,
I would like people to enter a workbook on Sheet1 but

have
to use a hyperlink in a cell to go to Sheet2 and on

Sheet2
use a cell hyperlink in order to go to Sheet3. (Disable
tab hoping.)
Is this possible in Excel? (using 2003)

Thanks



.


Don Guillett

glad it helped. However, they can still use ctrl+page down

--
Don Guillett
SalesAid Software

"DrillerThriller" wrote in message
...
Thank you that worked fine. I thought some huge macro
would be needed!
It's for testing so what is done is done on the other
sheets and Sheet3 is not linked.

-----Original Message-----
if you must

toolsoptionsviewsheet tabs

--
Don Guillett
SalesAid Software

"DrillerThriller"

wrote in message
...
Hi,
I would like people to enter a workbook on Sheet1 but

have
to use a hyperlink in a cell to go to Sheet2 and on

Sheet2
use a cell hyperlink in order to go to Sheet3. (Disable
tab hoping.)
Is this possible in Excel? (using 2003)

Thanks



.





All times are GMT +1. The time now is 05:37 PM.

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