ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Navigate in sheet with a button (https://www.excelbanter.com/excel-programming/330274-navigate-sheet-button.html)

Jonas G

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.

Andrew B[_4_]

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.


Mike Fogleman

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.





All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com