View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andrew B[_4_] Andrew B[_4_] is offline
external usenet poster
 
Posts: 42
Default Navigate in sheet with a button

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.