Insert Button in Developer Tab is Greyed out - Why? How do I fix it?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Insert Button in Developer Tab is Greyed out - Why? How do I fix it?

  1. #1
    Board Regular
    Join Date
    Nov 2002
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Insert Button in Developer Tab is Greyed out - Why? How do I fix it?

     
    In my Developer tab in Excel 2010, under the controls section, my Insert button is greyed out. I have a push button on the page that I put there years ago with excel 2003 and now I want to delete it. However, nothing I do is working. If I right click on it, nothing happens. If I left click it, it runs a macro that I assigned to it years ago. I cant even move the button around on the page.
    I have a feeling that the fact my Insert button is unavailable has something to do with the unablity to deal with this button. I did read to go to the File-Options-Advanced and under the Display options for Objects click the Show All button. I already did this.

    Does anyone know what I need to do to make the insert button available or to delete or move this push button from the page?

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,754
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Insert Button in Developer Tab is Greyed out - Why? How do I fix it?

    Is your Design Mode button enabled? If not, is the sheet protected, or Shared, or do you have multiple sheets selected?

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Insert Button in Developer Tab is Greyed out - Why? How do I fix it?

      
    RoryA, how stupid am I? The sheet was protected. Dumb, Dumb, Dumb.

    Thank you for that tip.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com