Large Ad

Collapse

Performance summary menu bug?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • funprofits
    New Member
    • Apr 2014
    • 2

    Performance summary menu bug?

    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)





    How can I fix this? Cheers
  • admin
    Moderator
    • Aug 2011
    • 1066

    #2
    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.

    Comment

    • funprofits
      New Member
      • Apr 2014
      • 2

      #3
      Thanks, all fixed now. Any reason why it became like that?

      Comment

      • admin
        Moderator
        • Aug 2011
        • 1066

        #4
        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.

        Comment

        Working...
        X