View code vanished on me? Help!

[bowlesj]

Hi, strange problem IMHO I am wondering if someone can figure this one out?

I clicked the developer tab then the clicked the view code button and placed the code below in. It worked as it always does and it is still working. The problem is I changed my mind and I want to remove it and when I go back and click the developer tab then the click the view code button it is not there. I tried a bunch of things to figure it out with no luck. This might help someone know what is going on. I have another sheet which is xls and it has the same sub routine. In that sheet I can go back the same way and find the code. This sheet where I can not find the code asked me some questions after I put the routine in and I decided to save it as xlsx. So I went back to find the xls version and it is missing from the folder. I guess I should check trash since it has all the other updates (just did - the xls is not in trash).

A related question. I am very good with MS-Access and its VBA but not very good with Excel and its VBA. Where do I learn more about the storing of Excel VBA? It seems a lot more complex than MS-Access.

Thanks,
John

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'UpdatebyExtendoffice6/1/2016
    Application.ScreenUpdating = False
    With Target
        .Worksheet.Cells.Interior.ColorIndex = 0
        .EntireRow.Interior.Color = vbYellow
        '.EntireColumn.Interior.Color = vbYellow
    End With
    Application.ScreenUpdating = True
End Sub

 

[MARK858]

If you saved it as xlsx then it won't have code in it as xlsx can't hold VBA.

I put the routine in and I decided to save it as xlsx.

 

[bowlesj]

If you saved it as xlsx then it won't have code in it as xlsx can't hold VBA.

 

[bowlesj]

Thanks MARK858. I guess I did not read the prompts correctly. In the past I have done it correctly. John

 

[MARK858]

You're welcome