HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS
 

I should elaborate on my first questions. I know how to use the "fill
handle". But what I want to do is protect most of my worksheet but type in a
month e.g. "JULY" and have all the cells below that month automatically fill
in the Next Month e.g. AUGUST, SEPTEMBER, OCTOBER etc. I do not want to have
to unprotect my worksheet and use the fill handle each time.

Thanks for your help,
--
Cathy
Port Charlotte, FL

HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS
 

The sort of thing that you need could be like the following

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveSheet.Unprotect
Select Case Target
Case Is = "JULY"
Target.Offset(1, 0) = "AUGUST"
Target.Offset(2, 0) = "SEPTEMBER"
Target.Offset(3, 0) = "OCTOBER"
Case Is = "AUGUST"
Target.Offset(1, 0) = "SEPTEMBER"
Target.Offset(2, 0) = "OCTOBER"
Target.Offset(3, 0) = "NOVEMBER"
End Select
ActiveSheet.Protect
End If
End Sub


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=561535