hi,

I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because i want to send to others.

Example: if I click on Apple from Sheet 1, I will go to Sheet2

Sheet1 Sheet2 Sheet3 Sheet4
Apple Apple Banana Orange
Banana
Orange


thanks for your help,
tuong

worthbeads

I don't realy think there is such a function, but I could be wrong

ScottGem

If I follow what you want, you want to use Sheet1 as a sort of table of contents where you can select an item and go to a sheet with more info. If that's the case, then why not name each sheet and the user can just click on the sheet tab?

And what does sending the sheet to others have to do wioth not using hyperlinks. If you are linking to areas within the same workbook that shouldn't matter.

You can, using VBA, set up a button that would find and got to another cell that has the same contents as the currently highlighted cell.

Wonder84lalala

Thanks for your reply,

If that's the case, then why not name each sheet and the user can just click on the sheet tab? [I have many worksheets]

And what does sending the sheet to others have to do wioth not using hyperlinks. If you are linking to areas within the same workbook that shouldn't matter. C38 =HYPERLINK('2006-06-30'!N20) [Cannot open the specified file]

You can, using VBA, set up a button that would find and got to another cell that has the same contents as the currently highlighted cell. [Can you show me the VBA codes?]

colbtech

post a sample of the spreadsheet, you will have to zip it. If it is too big, use save as and delete a load of sheets (leave enough for us to work with)

ScottGem

I'm not that good on Excel VBA, but the code would look something like this:

Application.Goto Reference:=Worksheets("ActiveCell.Value").Range("A 1"), _
Scroll:=True

That will go to the first cell of the sheer named in the currently selected cell.

colbtech

Is this what you require? Seems to me that it is just as easy to click on the tabs (unless you have lots & lots & lots......& lots of tabs)

Attached Files

Book2.zip (47.5 KB, 9 views)

cheechthecheechy

im not sure, but this *might* work.

u know how u can convert spreadsheets to web pages?

well u can convert them to webpages and like add links to differnet pages, but that would mean u cant edit them, or can you...

*twillight zone music*

hehehe

ScottGem

I agree with Colbtech that it would be easier to just use named tabs. However, to modify his code, you can do this with ONE generic button and the text in cells.

Use:
Sheets(ActiveCell.Value).Select

As long as the highlighted cell contains the name of an existing worksheet it will work.

Wonder84lalala

Cheech, how can I convert spreadsheets to web pages?
Colbtech, I have a lot of tabs.
Scott, do I use this code in Excel VBA?: Sheets(ActiveCell.Value).Select

Thanks for your helps.