Application.Goto Range:=Worksheets("Detail1") _
.Range("A1352"), Scroll:=True

would be in the click event of the button. Just change the details of the
location to go to for each of the other.

--
Regards,
Tom Ogilvy


"Keith-NB" wrote:

I dug around but didn't find this issue (although likely basic). I'm no VBA
programmer so step by step help would be appreciated.

I have a multi-sheet workbook. "Summary", "Detail1", "Detail2".

In the summary sheet, I would like to have three buttons:
1. When pressed would move the user to view "Detail1" with cell A1 in the
upper left corner.
2. When pressed would move the user to view "Detail1" with cell A1352 in
the upper left corner.
3. When pressed would move the user to view "Detail2" with cell CC1219 in
the upper left corner.

This would greatly ease my use of excel for a collaborative presentation.
Any help will be appreciated. These community boards are awesome!

Best,
Keith