what i am trying to create is not exactly an excel sheet. basically it is an admin section of Media Schedular Application which shows schedules defined in schedule controls in detail section and the header contains a ruler bar to show the scale in minutes. this schedular shows records for one month and of all four quarters of screen.
i have two panel controls named pnlHeader (no scroll bars) and pnlDetail (both vertical and horizontal scroll bars). when a user scrolls vertically up and down on pnlDetail, there is no effect on pnlHeader but when user will scroll horizontly on pnlDetail the other panel named pnlHeader will also scroll accordingly.
************************* SetNewGoal: while (GoalNotAchieved){} goto SetNewGoal; *************************