| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Directional buttons
I have a time sheet I want to put directional buttons on similar to a
calendar so you can move forward and backward to view different pay periods. Each pay period is 2 weeks long taking up 14 columns + 1 column for NOTES + 1 column for a border, so every pay period is 16 columns wide. Using the Macro Recorder in Excel 2007 it used this; ActiveWindow.ScrollColumn = 21 or 37 or 53 etc. Could I count what column the user is looking at and substitute the number after ActiveWindow.ScrollColumn = with n+ or – 16 ? Is this the best method for moving the focus for a user or can someone suggest something better? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking two cells that are bi-directional | Excel Discussion (Misc queries) | |||
| bi-directional dropdown boxes | Excel Programming | |||
| How do I set up a Speed and directional graph | Charts and Charting in Excel | |||
| can you do a bi-directional link in excel | Excel Discussion (Misc queries) | |||
| Bi-Directional Cell Linking | Excel Programming | |||
Threaded Mode
