Ĭhoose the Command Button (Active X Control) and then click the cell in which you want the button.You will now see the Developer tab on your ribbon, which will enable you to create command buttons.Ĭlick on Design Mode and a dialog box will appear. Under Customize the Ribbon on the right side of the dialog box, select Main tabs, and then select the Developer check box. Under Choose commands from on the left side of the dialog box, select Popular Commands. Ĭlick Customize Ribbon on the left side of the dialog box.On the File tab, choose Options to open the Excel Options dialog box. Unfortunately Office 2010 does not display the Developer tab by default, so you will need to enable it using the following procedure: A command button is a shortcut in Excel and is accessed through the Developer tab. This will be helpful when adding and removing items in the list, such as when new equipment is brought on line or a machine is retired. To maneuver more easily between worksheets, you can create a set of command buttons to run a macro that will take you back and forth to the lists on the different worksheets.
Ī down arrow should appear in the cells on the Log Sheet to access the list.(Don’t worry the drop down list will not show the blanks.)
Internet uptime logger plus#
Go to the worksheet with the list and highlight all the choices in the list plus blank rows for possible additions in the future.
Tracking Production Downtime to Improve Efficiency