Hide Colums before current date

[pulsarman605]

I have setup a freeze pane in this current workbook. But what I want to happen is when someone opens the workbook the columns scroll to the 1st of the month of the current month.... I don't want to hide previous columns, just want to scroll the current. Anyone know if this is possible.....

[LJMetzger]

Hi pulsarman605,

You probably need something like the following code (tested using Excel 2003):

ThisWorkbook:

Please Login or Register  to view this content.

If you double click on any cell in Row 1 the following will allow you to go to the first of the month:
Sheet1 Module:

Please Login or Register  to view this content.

Ordinary Code Module:

Please Login or Register  to view this content.

I noticed that you don't use 'Option Explicit'. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

[amromerodiaz]

Hello pulsarman605!

Mmmmmm..... I think you can try this:

This Workbook:

Please Login or Register  to view this content.

Now use one of these codes in one of your Modules.... here you have 2 options:

1. This code will scroll your workbook to the current DAY:

Please Login or Register  to view this content.

2. This code will scroll your workbook to the 1st of the month of current month:

Please Login or Register  to view this content.

Use the one that suits your needs, and Please let me know if that helped you!

Regards,

Alvaro

[watersev]

hi pulsarman605, welcome to Excelforum, option

[pulsarman605]

Cheers guys..... that was doing my head in!!!! ;-)