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
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
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks