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
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
      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Mar 22, 2018

        Glad to hear that the problem has been solved!
        Good luck :)

         

Resources