display or rename a sheet tab
Can info from cell be display or rename a sheet tab? Also is it possible to
add a double click function to a cell that pulls-up a specific sheet tab? |
display or rename a sheet tab
take a llook at the HYPERLINK function
You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56. =HYPERLINK("[Budget]June!E56", E56) To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September." To change the workshhet name to the same name as in a cell will require a macro. -- paul remove nospam for email addy! "* Kenneth *" wrote: Can info from cell be display or rename a sheet tab? Also is it possible to add a double click function to a cell that pulls-up a specific sheet tab? |
display or rename a sheet tab
Paul I appreciate the help, but I need a little more help. What I need is to
be able to input a name in a cell and have the sheet be automaticly rename to the name in the cell. I also need a way to unhide a sheet the a row on another sheet unhides at the same time. I hope this is a litle more clear. "paul" wrote: take a llook at the HYPERLINK function You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56. =HYPERLINK("[Budget]June!E56", E56) To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September." To change the workshhet name to the same name as in a cell will require a macro. -- paul remove nospam for email addy! "* Kenneth *" wrote: Can info from cell be display or rename a sheet tab? Also is it possible to add a double click function to a cell that pulls-up a specific sheet tab? |
All times are GMT +1. The time now is 08:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com