Forum Discussion
dawie human
Mar 21, 2018Copper Contributor
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
4 Replies
Sort By
- Haytham AmairahSilver Contributor
Hi,
Please go to File >> Options >> Advanced.
And make sure to show all objects in the workbook as below screenshot:
- dawie humanCopper Contributor
Hi,
The setting as suggested is ticked but Insert option still greyed out
David
- dawie humanCopper ContributorApology - the Worksheet protection was activated running a macro - when un-protecting the sheet the Insert option is now available
Dawie