A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
As usual, Joe's answer is incorrect. There is no design mode for the Mac 2016 VB editor.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How do I find the Design mode for the VBA editor in Excl 2016?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
As usual, Joe's answer is incorrect. There is no design mode for the Mac 2016 VB editor.
AAAARRRGGGHHH! Microsoft drives me nuts! Thanks, Bob.
Thanks, Joe. I did enable the Developer tab, but unlike earlier versions, no Design mode shows up there.
Enable developer tab in Excel 2016 by clicking on Excel > preferences > view at the bottom of the page check Developer tab