Enable Display Options in Excel to All (with Images)
Что is it: Insert option under Developer tab is greyed out and not allowing you click?
Почему отключен:
One of the reasons for this option is grayed out or disabled is because “Display options for this workbook For objects, show:” must be set as “Nothing (hide objects)” instead of “All”
Как Enable Display options:
Once you change or Enable Display options to “All” Insert Button will be enabled.
Шаг 1: GoTo Excel Options Menu and click on “Advanced”
Шаг 2: Set “For objects, show:” as “All” under “Display options for this workbook” from Advanced Menu options. And Click OK.
PinШаг 3: Вернитесь на вкладку Developer и проверьте кнопку Insert, теперь она должна быть включена.
Поделитесь им с друзьями и коллегами!
4 ответа
Awesome, looked a long time for this solution, thank you 🙂
In my case it was that my command buttons stopped being responsive and disappearing when moving between other sheets in my workbook.
And surely know that I did not disable this in the settings, nor did I get any notice about it from Mr. “Microsoft”!
С уважением,
Thanks for the help
I’m glad that it helped!