Offset Chart with named range

[MarkCBB]

Hi there,


I have put together a chart with "Spin buttons" (Form controls) that increase the data range by incrementing the offset formula in a Named range. However when I email the sheets from the workbook, and then have a look at the new worksheets that were emails the "Spin button" does not work. Even once I amended the named range to the Worksheet instead of the workbook.

The Spin button is in the chart on a chart sheet.

Does anyone know why this is happening and what I am do to rectify the challenge?

 

[MarkCBB]

I am using the email sender Addin form Ron de Bruin to send the worksheets.