For some reason the categories-based controls within some of my modules are not in line after module insertion, such as the Debtors module shown below. How do I fix this?
Stay up-to-date with Modano developments including new example models, content and learning exercises.
Hi Jeffrey,
The mis-alignment of controls is a bug in Excel that’s very annoying. We’ve built a workaround into Modano to address this as follows:
This should fix your workbook.
The issue is caused by the fact that Modano tries to insert controls such that they hide when their rows or columns are collapsed (if grouped) and/or hidden. If this issue persists on your computer, you can switch off this functionality by unchecking the ‘Allow controls to move and size with cells if possible’ check box within the Modano Options dialog – which you can access via the Modano tab, Options – as shown below:
This should resolve your issue one way or another.
M.