|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com