PDA

View Full Version : Performance summary menu bug?



funprofits
18th April 2014, 01:17 AM
I don't know what happened but now every time I open my spreadsheet the drop down menus are all scrunched up in the performance summary section. (pic below)


http://i.imgur.com/mejhQfp.png


How can I fix this? Cheers

admin
18th April 2014, 06:01 PM
Hi funprofits,

I recommend you unlock the spreadsheet (see Intro sheet for instructions) and then drag the drop down menus to where you would like them.

Right click on each menu first and then left click to drag.

funprofits
18th April 2014, 08:00 PM
Thanks, all fixed now. Any reason why it became like that?

admin
18th April 2014, 09:40 PM
Excel has certain quirks, one of which being that form elements which appear perfectly for some people end up out of place for others, especially if cells get resized. This is despite the Object Positioning being set to "Move but don't size with cells". There is a way to fix it using VB code but I'm reluctant to resort to coding to avoid people getting Macro warnings when they open the sheet.