12-02-2017 05:28 AM
12-03-2017 12:23 AM
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.
12-03-2017 06:10 AM
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.
01-01-2018 10:08 AM
I was having a similar issue and ur figuring out that it was due to "freeze frame" resolved it for me too. So thanks. Thumbs up to the Community. You guys do a far far better job than Microsoft Support. My attempt to use them earlier to resolve this issue was an exercise in futility.
01-01-2018 11:50 AM
I must say I’ve not had much luck with the “official” experts in any field. The clever guys are busy elsewhere, I suppose, and customer service is left to the erks.
The problem with The Community, is that some people will do no more than quote “solutions” they’ve read somewhere, and clearly haven’t actually tried them. So we have to rely on the occasional gems.
08-30-2019 06:43 AM
09-26-2020 06:11 AM
12-23-2020 11:50 AM
On the toolbar, click the View tab, and then Print Layout. Return to the Draw tab, and it should no longer be grayed-out.