| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select chart object in Excel 2007
Is it possible to select an existing chart object using VBA? The chart
should be selected as if I would have clicked on it manually (thick border around it). In Excel 2007. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select chart object in Excel 2007
activesheet.ChartObjects(1).Select
-- Regards, Tom Ogilvy "Luca Brasi" wrote: Is it possible to select an existing chart object using VBA? The chart should be selected as if I would have clicked on it manually (thick border around it). In Excel 2007. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select chart object in Excel 2007
thanks tom, but this does not select the chart object as if you would
have selected it manually (in Excel 2007). Or does it at your place?? I have just one Office 2007 installation available for doing some testing. Tom Ogilvy wrote: activesheet.ChartObjects(1).Select |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select chart object in Excel 2007
try this instead:
ActiveSheet.ChartObjects(1).Activate ActiveChart.ChartArea.Select You can use the name like "Chart 1" instead of the index number in Chart Objects. -- Regards, Tom Ogilvy "Luca Brasi" wrote: thanks tom, but this does not select the chart object as if you would have selected it manually (in Excel 2007). Or does it at your place?? I have just one Office 2007 installation available for doing some testing. Tom Ogilvy wrote: activesheet.ChartObjects(1).Select |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select chart object in Excel 2007
Tom, great! works!
Many thanks Tom Ogilvy wrote: try this instead: ActiveSheet.ChartObjects(1).Activate ActiveChart.ChartArea.Select You can use the name like "Chart 1" instead of the index number in Chart Objects. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display an object name in the Name Box in Excel 2007? | Charts and Charting in Excel | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| Excel 2007 - Could not load an object because it is not available | Excel Discussion (Misc queries) | |||
| Creating resizing macro - select chart as object? | Charts and Charting in Excel | |||
| How do I initiate the windows printer select object in Excel macro | Excel Programming | |||
Hybrid Mode
