If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA that the scroll can be set two scrolls freeze row 1-4 and columns A-G for row 1-4

Thread starter JMC57
Start date Dec 10, 2012
Tags

vba - help vba 2003 2010 form object

JMC57

Board Regular

Dec 10, 2012

I am trying to freeze row 1-4 and columns A-G for row 1-4 fixed without using the freeze pane function so that I can enter a scroll VBS function. Row 3 Column H- BJ has the following formula to show months =IF (ISNUMBER (L4), IF (MONTH (L4) =MONTH (M4),"", M4),"") to show the first Monday in each month. I would like to keep rows row 1-4 and columns A-G for row 1-4 fixed as part of <acronym title="visual basic for applications">VBA</acronym> code so that the scroll can be set two scrolls by week and month.
Sounds complicated and too much for me to handle. Any help or suggestions will be appreciated.
Thanks!