Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell value & hyperlink
I have a workbook with 250 sheets... named like so Sheet01...Sheet250
I want a cell to contain the number value of each sheet (01, 02, etc) while also being a hyperlink so when the cell is clicked the workbook automatically displays that sheet. Any ideas? |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell value & hyperlink
Hi Livin,
Visit David McRitchie's site and see his Table of Contents page at: http://www.mvps.org/dmcritchie/excel/buildtoc.htm --- Regards, Norman "livin" wrote in message news:wrlWe.97115$Ji4.15580@fed1read03... I have a workbook with 250 sheets... named like so Sheet01...Sheet250 I want a cell to contain the number value of each sheet (01, 02, etc) while also being a hyperlink so when the cell is clicked the workbook automatically displays that sheet. Any ideas? |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Cell value & hyperlink
This could be done with a combo box on Sheet01. Somewhere out-of-sight, list
the sheet names (Sheet01, Sheet02 etc) in a column then with the combo box properties set the InputRange i.e. $BA$1:$BA$250 and put a cell link value, say, BB1 then set this macro to run when the combo box is used:- Sub DropDown1_Change() NewSheet = Cells(1, 54) Sheets(NewSheet).Select End Sub "livin" wrote: I have a workbook with 250 sheets... named like so Sheet01...Sheet250 I want a cell to contain the number value of each sheet (01, 02, etc) while also being a hyperlink so when the cell is clicked the workbook automatically displays that sheet. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from one.xlsx cell to another two.xlxs cell & click back | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
Copy hyperlink from one cell to/as hyperlink in another cell | Excel Worksheet Functions | |||
Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions |