Forum Discussion
Draw tools are greyed out
I enabled the draw tools tab for my PC Excel 2016, but the tools are all greyed out.
Draw tools (along with many others) are disabled on protected sheets. Try unprotecting the sheet.
On the toolbar, click the View tab, and then Print Layout. Return to the Draw tab, and it should no longer be grayed-out.
I can’t check that at the moment, but I think you’ve solved it for me. The sheet isn’t protected but it is in xlsm format. I bet that’s the problem.
Many thanks.
Further to my previous post, the problem occurred on worksheets that used the "Freeze Panes/Rows" option. Nothing to do with the xlsm format after all. I unfroze a top row and the "Draw" items lit up.
acs42 where is the Freeze Panes/Rows option
