![]() |
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. |
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. |
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