excel-prgramming button

[Jeff]

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

 

[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 **

 

[Otto Moehrbach]

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

HTH Otto