LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Control in Chart Sheet

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Control Sheet Cedrun Excel Worksheet Functions 2 October 4th 06 09:48 PM
spinner control in chart sheet... please help! Anna Charts and Charting in Excel 3 August 10th 06 08:16 PM
Simple Stock Control Sheet alanled New Users to Excel 1 February 10th 06 06:33 PM
API for MS Chart Control bill Charts and Charting in Excel 1 September 12th 05 07:00 PM
Control End After the Sheet is Modified Paul Excel Discussion (Misc queries) 3 February 18th 05 05:12 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"