Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
I have an excel workbook with approx 30 worksheets, i want to create a menu
page wherby a cell (with the name of the worksheet in it) can be clicked on and this will take me direct to that work sheet, how do i do this ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
I have home-made XLA that should help: http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform To have tabs alpha ordered, right click on arrows left of tabs list, and select "Sort tabs" To select a sheet: Right-click on a cell and select "Select sheet" You can type the beginning of the name: it will select corresponding entry of the list. To validate: press Enter or double-click on a name To cancel: press Escape HTH -- AP "Graham7979" a écrit dans le message de news: ... I have an excel workbook with approx 30 worksheets, i want to create a menu page wherby a cell (with the name of the worksheet in it) can be clicked on and this will take me direct to that work sheet, how do i do this ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
Hi, You could try this solution. If I understand correctly, you want to be able to select cells which will then link to the sheet of the same name within the same workbook. Well, if you put this code in your sheet object which contains the menu in VBA, everytime you select a cell, it will go to the sheet of the same name. Since its in the menu sheet object, the selection change event wont affect the other objects. Private Sub Worksheet_SelectionChange(ByVal Target As Range) For Counter = 1 To Application.Sheets.Count If Application.ActiveCell.Value = Application.Sheets(Counter).Name Then Application.Sheets(Counter).Select End If Next Counter End Sub Kudos! -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=546284 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
Are you aware of the fact that XL has a resident (built in) table of
contents? Right click on those small arrows to the left of the sheet tabs. This displays a list of the first 15 tabs, plus it's expandable to an infinite scrolling list of all the sheets, where a 'double click' of a sheet name will place you in that sheet. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Graham7979" wrote in message ... I have an excel workbook with approx 30 worksheets, i want to create a menu page wherby a cell (with the name of the worksheet in it) can be clicked on and this will take me direct to that work sheet, how do i do this ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheets
Bastien Mensink's ASAP Utililities will do this with a couple of clicks. Its
a free add-in which contains about 300 usefull utilities. Go to www.asap-utilities.com "Graham7979" wrote: I have an excel workbook with approx 30 worksheets, i want to create a menu page wherby a cell (with the name of the worksheet in it) can be clicked on and this will take me direct to that work sheet, how do i do this ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Worksheets | Excel Worksheet Functions | |||
I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
Linking across worksheets not working as desired | Excel Worksheet Functions |