Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm making a calendar where each column represents one day and each row
represents a month. It looks something like this: A B C D ....... I J ....... P Q Month Mon Tue Wed ...... Mon Tue ..... Mon Tue Jan 1 2 3 15 16 .... 22 23 Feb 12 13 .... 19 20 Row 1 and Column A are frozen, (always displayed in the screen). I would like to design a 'fast forward' button. When clicked, this buttons scrolls horizontally to the right to put the nearest MONDAY (on the right) adjacent to Column A. and similarly a 'Rewind' button that scrolls horizontally to the left to put the nearest MONDAY (on the left) adjacent to Column A. In other words, i want to be able to scroll horizontally one week at a time whether it's forward or backward. i'm using Excel 2003. Many thanks Tendresse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scroll data into 3 columns | Excel Discussion (Misc queries) | |||
When I freeze rows I want it to scroll 1 at a time, not 3 at a tim | Excel Worksheet Functions | |||
Every time I scroll up or down, my picture disappears | Excel Discussion (Misc queries) | |||
Why does my tab key scroll over about 10 columns | Excel Discussion (Misc queries) | |||
Scroll two columns on right while left is stationary | Excel Discussion (Misc queries) |