| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to return to top of spreadsheet
Is there a way to create a macro/button that will return me to the top of the
spreadsheet? thanks in advance -- Cindy B |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
button to return to top of spreadsheet
a couple of ways
Sub CtrlHome() SendKeys "^{home}" End Sub Sub gghome() 'Tom Ogilvy rw = ActiveWindow.SplitRow + 1 col = ActiveWindow.SplitColumn + 1 Cells(rw, col).Select End Sub -- Don Guillett SalesAid Software "Cindy B" wrote in message ... Is there a way to create a macro/button that will return me to the top of the spreadsheet? thanks in advance -- Cindy B |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
button to return to top of spreadsheet
Cindy
Sub Top() Range("A1").Select End Sub Assign to a button. OR just hit CTRL + Home to go to top without using a macro or a button. Gord Dibben Excel MVP On Mon, 7 Mar 2005 15:53:04 -0800, "Cindy B" wrote: Is there a way to create a macro/button that will return me to the top of the spreadsheet? thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
button to return to top of spreadsheet
Thanks Don and Gord -
Didn't know the Ctrl+Home worked - so will see if that will do it for them - if not - thanks for the code - I'll file that in case they really need the buttons... thanks again - it is so great to get help on these forums!!! Your Awesome! Cindy "Cindy B" wrote: Is there a way to create a macro/button that will return me to the top of the spreadsheet? thanks in advance -- Cindy B |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
button to return to top of spreadsheet
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Button on the Keyboard | Excel Worksheet Functions | |||
| use button to return random numbers | Excel Worksheet Functions | |||
| Using 'return' button in Excel for Macs | Excel Discussion (Misc queries) | |||
| ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS | New Users to Excel | |||
| return a value from VB to a spreadsheet | Excel Programming | |||
Linear Mode
