Help!

Private Sub Worksheet_SelectionChange

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  office file not opening  
Author Message
MarkDallas



Joined: Oct 13, 2007
Posts: 2



PostPosted: Sat Oct 13, 2007 10:07 pm    Post subject: Private Sub Worksheet_SelectionChange

Hello. I know this is a basic question, but it is actually a roadblock for me in trying to learn VBA. I did the basic code, closed my worksheet, reopened worksheet, clicked Enabled Macros, but nothing happens in my worksheet when I change something. Is there a special way to run a private macro?

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

'Sets all rows to no color and then to yellow on change in cells
Rows.Interior.ColorIndex = xlColorIndexNone
Target.EntireColumn.Interior.ColorIndex = 36
Target.EntireRow.Interior.ColorIndex = 37

End Sub
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum