Restore missing button and drop down controls in Excel

Category: MS Excel

Have you ever faced a situation where suddenly all the buttons, drop downs and various controls are missing from your Excel spreadsheet? Well, it’s not gone but it is hidden. Here is the setting to make the controls visible.

Go to File > Options > Advanced > Display options for this workbook > For objects, show: > Select All

excel-options-show-button-dropdown

Share

1 comment

Your email address will not be published. Required fields are marked *

  1. Robin Clay says:

    Alas ! That didn’t work. It WAS set to All.
    So I change dit to M=None, that made no difference, so i changed it back to All – but still no buttons 🙁
    Luckily, it’s only two buttons, and the VBA routines are still there, so I can copy it to a previous generation backup.