Offset Chart with named range

MarkCBB

Active Member
Joined
Apr 12, 2010
Messages
497
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?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

MarkCBB

Active Member
Joined
Apr 12, 2010
Messages
497
I am using the email sender Addin form Ron de Bruin to send the worksheets.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,775
Messages
5,470,709
Members
406,718
Latest member
waseem11

This Week's Hot Topics

Top