Hi,

Interesting. Using xl2003 I was able to reproduce the problem.

2 forms checkboxes on a chartsheet.
First linked to range Sheet1!$A$1
Second to named range MyCk which in turn is referenced to Sheet1!$A$1

On saving and re opening workbook the second checkbox is no longer
referencing MyCk.

I did find though that creating a sheet level named range,
Sheet1!MyCk which references Sheet1!MyCk
did retain the link.

Cheers
Andy


Anderflash wrote:
Well, I put a chart sheet with a chart that depends on the scroll bar
control. This control is also on the Chart sheet. I change the value of the
scroll bar, it changes the value of the link cell and finally the link cell
modifies the chart.

1) If a put a name to the cell (like 'variable') and put 'variable' on the
link cell field, when I save, close and open the .xls, the link cell field
will be empty.
2) If a put Sheet1!A1 on the link cell field (supposing that my cell is A1)
and save, close and open the .xls, the link cell field will be correct (it
will have Sheet1!A1).

The item '1)' occurs if the scroll bar is on the chart sheet. If I put the
scroll bar on the worksheet, it won't fail.

Why do the controls of the Form Bar that have link cell field and are on a
Chart Sheet fail when I put a named range?

I hope my question is clear to understand.

PS: Do a chart sheet (can be empty - F11 on a empty cell), put a check box
from the Form Bar, put a name on cell A1 (variable), put variable on the link
cell of the check box. Save, close and open. See whether variable is at the
link cell field.
Now put Sheet1!A1 on the link cell field. Save, close......and so on.