swapnilushinde
New Member
- Joined
- Jun 16, 2011
- Messages
- 2
Hello
I am newbie to excel VBA programming. I have charts in power-point which are linked to excel sheets. by right clicking on chart and then 'Edit data' I could open associated workbook. but it is not landing to appropriate sheet in that workbook.(It just opens the workbook !)
I need to make changes such that 'Edit data' option opens the workbook and bring proper sheet. I am planning to do it in this way -
Writting a macro in excel with open_workbook event. When this macro triggers whether workbook has been opened through PPT. If so it will move to proper sheet and opens it. Rest of part is easy. but how to trigger macro in excel and find whether it has been triggerd by click on 'Edit data' is confusing.
It would be so kind if you explain me how to do it or any other way to do the same..
I am newbie to excel VBA programming. I have charts in power-point which are linked to excel sheets. by right clicking on chart and then 'Edit data' I could open associated workbook. but it is not landing to appropriate sheet in that workbook.(It just opens the workbook !)
I need to make changes such that 'Edit data' option opens the workbook and bring proper sheet. I am planning to do it in this way -
Writting a macro in excel with open_workbook event. When this macro triggers whether workbook has been opened through PPT. If so it will move to proper sheet and opens it. Rest of part is easy. but how to trigger macro in excel and find whether it has been triggerd by click on 'Edit data' is confusing.
It would be so kind if you explain me how to do it or any other way to do the same..
