Forum Discussion

dawie human's avatar
dawie human
Copper Contributor
Mar 21, 2018

VBA Command Button

Good day,

 

Excel Office 365, the Insert Button under Controls is greyed out - all other buttons under Developer is active. Rgds David

Macros & VBA
Need Help

4 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 21, 2018

    Hi,

     

    Please go to File >> Options >> Advanced.

    And make sure to show all objects in the workbook as below screenshot:

    • dawie human's avatar
      dawie human
      Copper Contributor
      Mar 22, 2018

      Hi,

       

      The setting as suggested is ticked but Insert option still greyed out

       

      David

       

       

      • dawie human's avatar
        dawie human
        Copper Contributor
        Mar 22, 2018
        Apology - the Worksheet protection was activated running a macro - when un-protecting the sheet the Insert option is now available

        Dawie

Resources