P
peter
I am developing a large workbook which has, among other facitilities,
an option for the user to select a data record, click a button and
have that data displayed on a chart. As part of the functionality,
the code selects a text box and enters an appropriate title.
It seemed to work alright until one user tried to select the chart and
paste it into a Powerpoint document. The copy and paste worked, but on
returning to Excel she got the message 'Object doesn't support this
property or method.'
On investigation, it seemed that the selection of the chart was over-
riding the selection of the text box, so the code was trying to apply
text box methods to the chart. I tried putting a 'DoEvents' command
after the selection of the text box, but no effect. Then I tried
selecting a specific cell prior to selecting the text box, and this
seemed to do the trick.
So the immediate problem is solved, but I don't really understand why,
and that makes me uncomfortable. Any ideas?
Peter
an option for the user to select a data record, click a button and
have that data displayed on a chart. As part of the functionality,
the code selects a text box and enters an appropriate title.
It seemed to work alright until one user tried to select the chart and
paste it into a Powerpoint document. The copy and paste worked, but on
returning to Excel she got the message 'Object doesn't support this
property or method.'
On investigation, it seemed that the selection of the chart was over-
riding the selection of the text box, so the code was trying to apply
text box methods to the chart. I tried putting a 'DoEvents' command
after the selection of the text box, but no effect. Then I tried
selecting a specific cell prior to selecting the text box, and this
seemed to do the trick.
So the immediate problem is solved, but I don't really understand why,
and that makes me uncomfortable. Any ideas?
Peter