Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark Stephens
 
Posts: n/a
Default select a chart without the selector handles showing?

I thought maybe


Application.Screenupdating = false


may do it but no.


Is it possible does anyone know to select your chart but not have the nadles

markers show?


Kind regards, Mark



  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

One almost never needs to select a chart (or any other object for that
matter). Set a variable to the chart in question and use that variable.

dim aChart as chart
set aChart=activesheet.chartobjects(1).chart
msgbox achart.seriescollection.count

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
I thought maybe


Application.Screenupdating = false


may do it but no.


Is it possible does anyone know to select your chart but not have the nadles

markers show?


Kind regards, Mark




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scrollbar on Chart Jumps to Left when Chart is Clicked Bob Charts and Charting in Excel 5 May 1st 05 02:06 AM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"