Forum Discussion
hide print area for whole workbook
Excel (Office Pro+ 2016) has randomly started showing the print area in every worksheet in every workbook. The only method I've found to hide them again involves File - Options - Hide Page Break...
Hi Jan,
Thanks for your reply. I've no idea why it's suddenly started happening, as I'm not doing anything differently, and am not accessing print features.
I'm aware of the macro workaround, but that would mean converting xlsx to xlsm (all my workbooks) and this will cause issues when sharing by email (given my company's hyper-active IT security). It's not really a long-term solution, but thanks any way...
Thanks for your reply. I've no idea why it's suddenly started happening, as I'm not doing anything differently, and am not accessing print features.
I'm aware of the macro workaround, but that would mean converting xlsx to xlsm (all my workbooks) and this will cause issues when sharing by email (given my company's hyper-active IT security). It's not really a long-term solution, but thanks any way...
I just wanted to share the macro in case you needed a quick fix for any workbook open at that moment.
- Thanks - I appreciate it 🙂