Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Drop-Down Box
I've got a 50 sheet excel document and i want to create names to get me to A1 on every page, so I don't have to scroll left and right all the time. So, here's my problem. I would like to increase the number of names shown when i click the drop down box. Right now it shows 7, in Office 2003. I would love to increase that to show 50, or else I’m not really getting the functionality I’m looking for. I think this will take some kind of registry tweak. Does anyone know how/where I can? Thanks in advance, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=501801 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Drop-Down Box
Ctrl-Home should take to to the top left cell (usually A1).
But you could also define a name that refers to A1: Insert|Name|Define Names in Workbook: Home (that was the name I used) Refers to: =indirect("a1") Then no matter where I was, I could hit F5, type Home and hit enter--and off to A1 of the activesheet. cbh35711 wrote: I've got a 50 sheet excel document and i want to create names to get me to A1 on every page, so I don't have to scroll left and right all the time. So, here's my problem. I would like to increase the number of names shown when i click the drop down box. Right now it shows 7, in Office 2003. I would love to increase that to show 50, or else I’m not really getting the functionality I’m looking for. I think this will take some kind of registry tweak. Does anyone know how/where I can? Thanks in advance, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=501801 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Drop-Down Box
I know how to create a name, that wasn't my question... A1 isn't what i'm looking for, it's to travel to any sheet in my file, without having to scroll left and right, on the bottom, or up and down on the names list. I want to make the names list list more names than it does now. Anyone know how? Thanks, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=501801 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Drop-Down Box
I read your question as asking how to get to A1 of the current sheet without
scrolling right or left or up or down. But you meant you want to go to A1 of any sheet by selecting the name that's assigned to A1 of that sheet. I don't know a way of expanding the Namebox, but you could use a floating toolbar: http://contextures.com/xlToolbar01.html from Debra Dalgleish's site. Modify this portion: With ctrl .Width = 300 .AddItem "Click Refresh First" .OnAction = ThisWorkbook.Name & "!changethesheet" .Tag = "__wksnames__" .DropDownLines = 50 '<--added End With And change this portion: If wks Is Nothing Then Call RefreshTheSheets MsgBox "Please try again" Else wks.Select wks.Range("a1").Select '<-- added End If cbh35711 wrote: I know how to create a name, that wasn't my question... A1 isn't what i'm looking for, it's to travel to any sheet in my file, without having to scroll left and right, on the bottom, or up and down on the names list. I want to make the names list list more names than it does now. Anyone know how? Thanks, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=501801 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down box leading to another drop down box | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |