excel-prgramming button

J

Jeff

button on bottom of large page - would like to program button for 1 click and
it goes back to top of page
 
P

Paul B

Jeff, why not use ctrl+Home? or if you want a macro, Range("A1").Select
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
O

Otto Moehrbach

Sub ToTop()
With ActiveWindow
.ScrollRow = 1
.ScrollColumn = 1
End With
End Sub

HTH Otto
 
Top