+ Reply to Thread
Results 1 to 4 of 4

Working with shapes - naming and deleting

  1. #1
    Registered User
    Join Date
    08-13-2008
    Location
    Australia
    Posts
    3

    Unhappy Working with shapes - naming and deleting

    OK - I'm not good with VBA - I use code that I see on the net, and try to modify and learn from it - sometimes succesfully.

    I have a worksheet where a macro runs to create a shape :
    Please Login or Register  to view this content.
    I don't think the naming of the shape is working - and I want to name the shape so that I can refer to it, and in another macro, delete it.

    I'm really struggling with this - can anybody help please?
    Last edited by davesexcel; 03-07-2012 at 09:31 PM. Reason: Code tags required when showing VBA code

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Working with shapes - naming and deleting

    Hello,
    Could you just be missing the quotes?
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-13-2008
    Location
    Australia
    Posts
    3

    Re: Working with shapes - naming and deleting

    I think that could be it!

    So now, how do I reference this named shape, to delete it?

    Is it as simple as

    Code :

    With sheets("Worksheet 1")
    .ButtonHide.Visible=false

    Or

    .range("ButtonHide").visible = false

    (neither of which seem to work)


    Thanks again.
    Last edited by JusCor; 03-07-2012 at 10:30 PM.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Working with shapes - naming and deleting

    Please Login or Register  to view this content.

+ 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