Posts by lecker

Re: Worksheet_SelectionChange not working in Excel 2016

[ATTACH=CONFIG]70019[/ATTACH]

Attached is a better copy of the file.

Thanks again!

Re: Worksheet_SelectionChange not working in Excel 2016

If you open the file in Excel 2007 and click on row 4 or 5 the chart will populate.
If you open the file in Excel 2016 it does not work.

Thanks for the help!

Re: Worksheet_SelectionChange not working in Excel 2016

Sorry for my ignorance...how can I post my workbook?

Re: Worksheet_SelectionChange not working in Excel 2016

I'm sorry about the code tags, I am very new to this.
When I click on a cell the chart does not update as it does in Excel 2007

Re: Worksheet_SelectionChange not working in Excel 2016

I just changed the word ActiveCell to Target and get the same result.

I have a file that takes the data from a row and puts it into a chart, if you select a different row you get a different chart.
This works well in Excel 2007, we are changing to 2016 and the code is not working.
I have looked through many posts but can't get the answer that works.
I have tried

Application.EnableEvents=True

...does not help.
This is what I use:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Row > 2 And ActiveCell.Row < 500 Then _
      ActiveSheet.Calculate
     End Sub

Any suggestions?