+ Reply to Thread
Results 1 to 5 of 5

Can't Insert Shape to sheet [1]

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Can't Insert Shape to sheet [1]

    In sheet [1], I attached macros to different shapes (Arrows) and the file has been working fine. When I opened the file today, all the shapes were missing and I can't insert a new shape into this sheet? When I draw the shape, I can see the shape but on releasing the mouse the shape disappears? I can enter a shape in a different sheet but not the first one?
    Thanks in advance
    Last edited by Aland2929; 01-26-2012 at 10:11 AM.

  2. #2
    Registered User
    Join Date
    01-13-2009
    Location
    Prince Rupert, BC
    MS-Off Ver
    Excel 97, 2003
    Posts
    54

    Re: Can't Insert Shape to sheet [1]

    Hi Aland2929,
    Is there a possibility that the shapes you are drawing are the same color as your form background. Eg. If your shapes default color is white with no border it will disappear when you release the mouse on a no color form background.

    Hope this helps

    Mister P

  3. #3
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Can't Insert Shape to sheet [1]

    Perhaps:

    File - Options
    Select 'Advanced' section
    Scroll about half way down to the 'Display options for this workbook' section and make sure 'All' is selected in the 'For objects, show:' setting.
    Good luck.

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Can't Insert Shape to sheet [1]

    Thanks for your response. Neither of the two suggestions apply. I have inserted a new sheet and re-created the shapes without a problem. I deleted the old sheet. I don't know why it happened but inserting a new sheet seemed the quickest solution.

  5. #5
    Registered User
    Join Date
    08-19-2012
    Location
    Smith's, Bermuda
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Can't Insert Shape to sheet [1]

    Thank you for this suggestion, it worked for me and solved a problem I was having, and also solved another similar problem which I had already given up on. I appreciate your help.

+ 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