Closed Thread
Results 1 to 2 of 2

#application caller shapes(activeshape.name) #

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,185

    #application caller shapes(activeshape.name) #

    i have code
    Sub Macro2()

    With ActiveSheet.ChartObjects(1).Chart
    ActiveSheet.Shapes("Chart 24").Fill.Visible = msoFalse
    ActiveChart.PlotArea.Select
    Selection.Format.Fill.Visible = msoFalse
    End With
    End Sub

    ' how to make dinamis shapes name ActiveSheet.Shapes("Chart 24")
    'become activesheet.shapes(Application.caller) but not run

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,556

    Re: #application caller shapes(activeshape.name) #

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    (Probably forum-induced)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Misunderstanding code and how to end Application Caller-Please help
    By lucasoliver in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2016, 01:57 PM
  2. Explain Application.Caller and OnAction
    By shawnvw in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2014, 06:11 AM
  3. [SOLVED] Using Application.caller with Shapes
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2014, 05:07 AM
  4. [SOLVED] application caller
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2006, 07:35 AM
  5. Application.Caller
    By Marcelo in forum Excel General
    Replies: 6
    Last Post: 06-23-2006, 10:10 AM
  6. Application.Caller syntax for worksheets?
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2006, 05:38 PM
  7. [SOLVED] Row = Application.Caller.Row
    By Charles Woll in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1