If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Buttons to navigate and drop down menus
Hi
I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#2
|
|||
|
|||
Creating Buttons to navigate and drop down menus
Hi Ryan
Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#3
|
|||
|
|||
Creating Buttons to navigate and drop down menus
You can also insert a hyperlink if you want
Insert Hyperlink Place in the document -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#4
|
|||
|
|||
Creating Buttons to navigate and drop down menus
No i mean i need actual buttons, like a website on the excel page to navigate
throughout the workbook. Any Ideas? Thanks "Ron de Bruin" wrote: Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#5
|
|||
|
|||
Creating Buttons to navigate and drop down menus
Thanks that could work, what about making it look like a standard square,
grey button with the page text inside. Also any ideas on the drop down menu? Thanks Ryan "Ron de Bruin" wrote: You can also insert a hyperlink if you want Insert Hyperlink Place in the document -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#6
|
|||
|
|||
Creating Buttons to navigate and drop down menus
You can add a button from the forms toolbar and assign a macro like this
ActiveSheet.Previous.Select ActiveSheet.Next.Select -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... No i mean i need actual buttons, like a website on the excel page to navigate throughout the workbook. Any Ideas? Thanks "Ron de Bruin" wrote: Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#7
|
|||
|
|||
Creating Buttons to navigate and drop down menus
You need VBA to create a Dropdown with sheets in your workbook
Do you want that ? Don't you like the right click on the arrows -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Thanks that could work, what about making it look like a standard square, grey button with the page text inside. Also any ideas on the drop down menu? Thanks Ryan "Ron de Bruin" wrote: You can also insert a hyperlink if you want Insert Hyperlink Place in the document -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
#8
|
|||
|
|||
Creating Buttons to navigate and drop down menus
Type the list of valid entries in a single column (this column can be hidden,
if desired). Select the cell or cells that will display the list of entries, choose Data - Validation, and select the Settings tab. From the Allow drop-down list, select List. In the Source box, enter a range address or a reference to the items in your sheet. Make sure the In-cell dropdown box is selected. This technique does not require any macros. You can download ' Andrew's Utilities, besides the Worksheet index - there are a whole lot of great features you can use in Excel. http://www.andrewsexceltips.com/tips.htm To create a worksheet index - from Andrews Utilities Sub WorksheetIndex() On Error GoTo Terminator Dim ws As Worksheet, wsIndex As Worksheet Dim myRow As Long Call SetCalcSetting Set wsIndex = ActiveWorkbook.Worksheets.Add _ (Befo=ActiveWorkbook.Sheets(1)) wsIndex.Name = "Sheet Index" Range("A1") = "Sheet Index" ActiveWorkbook.Names.Add Name:="Sheet_Index", RefersToR1C1:= _ "='Sheet Index'!R1C1" ActiveCell.Font.Bold = True myRow = 3 For Each ws In ActiveWorkbook.Worksheets If ws.Name wsIndex.Name Then wsIndex.Hyperlinks.Add _ anchor:=wsIndex.Cells(myRow, 1), _ Address:="", _ SubAddress:=ws.Name & "!A1", _ TextToDisplay:=ws.Name myRow = myRow + 1 End If Next wsIndex.Columns("A:A").EntireColumn.AutoFit Call SetCalcSetting("Restore") Exit Sub Terminator: MsgBox "Sorry, there seems to be a problem... " & vbCrLf & _ "Perhaps the Sheet Index already exists? ", vbExclamation, "Create Worksheet Index" Call SetCalcSetting("Restore") End Sub "ryan_dude" wrote: No i mean i need actual buttons, like a website on the excel page to navigate throughout the workbook. Any Ideas? Thanks "Ron de Bruin" wrote: Hi Ryan Maybe ? Ctrl Page Up and Ctrl Page Down Also i need to create a drop down menu, again a form tool?? right click on the arrows on the left of your first tab -- Regards Ron de Bruin http://www.rondebruin.nl "ryan_dude" wrote in message ... Hi I need to create buttons so i can navigate from one sheet to the other inside a workbook, is there some kind of form tool to do this with? Also i need to create a drop down menu, again a form tool?? Many Thanks in advanced, Ryan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating navigation buttons on a worksheet | ryan_dude | New Users | 2 | December 20th, 2005 05:15 PM |
Can I use a drop down list to navigate to other spreadsheets | djp | Worksheet Functions | 3 | December 7th, 2005 01:17 PM |
How can I make a drop down menu to navigate in a PowerPoint kiosk. | GreenbuildR | Powerpoint | 11 | January 12th, 2005 04:15 PM |