+ Reply to Thread
Results 1 to 4 of 4

I can't use shape tool on one worksheet

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    I can't use shape tool on one worksheet

    I want to draw a box on my worksheet but the tools are not active (greyed out). This occurs on one of several worksheets in my workbook. All of the other sheets have access to the icon. My entire workbook is too large to post so I made a copy of the offending worksheet and it is attached.

    I need to put a rectangle or square on a cell and activate it for a macro, which I am able to do in all other worksheets, but not for the one in the attachment.

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: I can't use shape tool on one worksheet

    The sheet is protected. You have to unprotect it first, then the tools will be available.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: I can't use shape tool on one worksheet

    Thanks so much, I should have thought of that - I unprotected and it brought the tools back. I will mark thread solved.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: I can't use shape tool on one worksheet

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking shape on worksheet
    By VBA_Leaner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2015, 10:59 AM
  2. Control Tip for Shape in worksheet
    By surajitbose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 10:14 AM
  3. Detailed Tool Tip when mouse is over a Shape/Object
    By AlphaSkidz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 05:18 PM
  4. Add shape without selecting worksheet or cell
    By rgarber in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2010, 01:24 AM
  5. Add Shape in Protected Worksheet
    By ct11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2009, 10:15 AM
  6. Shape/picture name in a worksheet
    By neta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2006, 11:00 AM
  7. [SOLVED] I can see a worksheet, but I can't type in it or use the tool bar
    By wanda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2006, 06:57 PM

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