Thread: Window Freeze
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default Window Freeze

I have a spreadsheet that has titles in Columns A5:A55. Column A is frozen.
In Row 2 (B2:IV2) I have monthly dates B2 = 1/1/2008, B3 = 2/1/2008, B3
=3/1/2008, etc.

I am trying to create code in the sheet (sheet 4) that will open the sheet
and position the sheet to the current date, i.e. if today is 7-13-2008
opening sheet 4 will position the current month (7-1-2008) next to column A.
This would be in
column H.


Thanks for any Help!

Ronbo