+ Reply to Thread
Results 1 to 4 of 4

Show/Hide Shape VBA

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Show/Hide Shape VBA

    Within a VBA code, I have a line of code at the start of the code to show a shape. At the end of code I hide the same shape. The problem is that when I run the code, the shape is not visible. If I "step" through the code and place a stop at the line ActiveSheet.Shapes("PushPin_598").Visible = True, the shape will show up. I can't figure out why the shape won't show up if I run it with no stops and it does show up when I step through the code. Thanks in advance for any comments.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Show/Hide Shape VBA

    why not eliminate hide line ?
    If solved remember to mark Thread as solved

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Re: Show/Hide Shape VBA

    Thanks for suggestion but my manager does not want to see the shape once the code has completed executing completly. Thanks.

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Show/Hide Shape VBA

    your code seems correct, attach a samplefile for testing

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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