Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detecting if embedded chart is the active object 1

Status
Not open for further replies.
Stretchwickster

Stretchwickster

Programmer
Apr 30, 2001
1,746
GB
I have three embedded charts on a sheet. How do I detect if one of them is currently active? Do I use the TypeName command? Clive [infinity]
 
Sort by date Sort by votes
Test against Selection.Parent.Name

If selection.parent.name = "chart Name" then
'Do stuff
elseif selection.parent.name = "Chart2 Name" then
etc etc etc Rgds
~Geoff~
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
946
morechocolate
morechocolate
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
523
SkipVought
S
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
954
dhookom
dhookom
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
376
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top