Navigate in sheet with a button

I'va made a projectplan and would like to navigate to "today" by using a
command button.

Any clues would be greatly appreciated.

Hi Jonas
You could:
1. Create an object such as a rectangle from the drawing toolbar.
2. Right-click on the object and assign a macro to it.
3. The macro could be:

Sub GoToday ()
Sheets("Today").Activate
End Sub

HTH

Andrew B

Jonas G wrote:
> I'va made a projectplan and would like to navigate to "today" by using a
> command button.
>
> Any clues would be greatly appreciated.

The simplest way to navigate a workbook is to Insert/Hyperlink. You create
the Display Text and enter the cell or Named Range to go to.

Mike F
"Jonas G" <Jonas [email protected]> wrote in message
news:[email protected]...
> I'va made a projectplan and would like to navigate to "today" by using a
> command button.
>
> Any clues would be greatly appreciated.