Analysis for Office - Default the Task Pane to display on open
After reading through SCN there are undocumented commands to show/hide the task pane Analysis, Component and Information tabs. There does not appear to be a way to toggle the whole task pane off/on. What we would like to do is make the Task Pane visible by default and not requiring the user to go to the Analysis tab and select display in the design panel buttons each time the workbook is open. Is there are setting that can be applied or macro created? We are using AFO v1.4.8 and Excel 2010. Thanks for you help.