| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Link embedded chart to a commandbutton?
I have a embedded chart which I wish to show the chart when I press a
commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Hi,
The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Many thanks Andy, I shall try that out on friday when i am back at work
-- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Andy,
Tried it and I get a syntax error message -- Bob "Bob" wrote: Many thanks Andy, I shall try that out on friday when i am back at work -- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Probably because of the email formatting.
The syntax should be on 1 line. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = _ Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy, Tried it and I get a syntax error message -- Bob "Bob" wrote: Many thanks Andy, I shall try that out on friday when i am back at work -- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Andy thanks for that.
At the moment when I press the commanbutton(3) I can see the chart underneath the active page? -- Bob "Andy Pope" wrote: Probably because of the email formatting. The syntax should be on 1 line. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = _ Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy, Tried it and I get a syntax error message -- Bob "Bob" wrote: Many thanks Andy, I shall try that out on friday when i am back at work -- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Sorry I don't understand what you mean?
On a worksheet enter 1,2,3 in cells A1:A3 Select A1:A3 and insert a chart on to the worksheet. Using the Forms toolbar add a button to the worksheet. Right click the button and assign macro. The code should be in a standard code module. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy thanks for that. At the moment when I press the commanbutton(3) I can see the chart underneath the active page? -- Bob "Andy Pope" wrote: Probably because of the email formatting. The syntax should be on 1 line. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = _ Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy, Tried it and I get a syntax error message -- Bob "Bob" wrote: Many thanks Andy, I shall try that out on friday when i am back at work -- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link embedded chart to a commandbutton?
Andy,
I works well now Thanks very much -- Bob "Andy Pope" wrote: Sorry I don't understand what you mean? On a worksheet enter 1,2,3 in cells A1:A3 Select A1:A3 and insert a chart on to the worksheet. Using the Forms toolbar add a button to the worksheet. Right click the button and assign macro. The code should be in a standard code module. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy thanks for that. At the moment when I press the commanbutton(3) I can see the chart underneath the active page? -- Bob "Andy Pope" wrote: Probably because of the email formatting. The syntax should be on 1 line. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = _ Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... Andy, Tried it and I get a syntax error message -- Bob "Bob" wrote: Many thanks Andy, I shall try that out on friday when i am back at work -- Bob "Andy Pope" wrote: Hi, The basic code would be, which will toggle visibility of first chartobject on sheet. Sub Button2_Click() ActiveSheet.ChartObjects(1).Visible = Not ActiveSheet.ChartObjects(1).Visible End Sub Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob" wrote in message ... I have a embedded chart which I wish to show the chart when I press a commandButton and hide the chart when I press either the same button or another one. -- Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of an embedded link in an Excel worksheet | Excel Discussion (Misc queries) | |||
| How do I link to an embedded object | Excel Discussion (Misc queries) | |||
| Link to embedded spreadsheet | Links and Linking in Excel | |||
| Link To Embedded Object | Excel Discussion (Misc queries) | |||
| Pulling Embedded LInk Out of Cell | Excel Discussion (Misc queries) | |||
Linear Mode
