| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Navigate in sheet with a button
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 wrote in message ... I'va made a projectplan and would like to navigate to "today" by using a command button. Any clues would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use and navigate through option button on w/sheet | Excel Discussion (Misc queries) | |||
| How do i navigate between sheet tabs from my keyboard? | Excel Discussion (Misc queries) | |||
| I can't navigate my sheet with my arrow keys. suggestions? | Excel Discussion (Misc queries) | |||
| How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Hybrid Mode
