If your spreadsheet is only for you to use then using these grey command buttons to trigger all your macros maybe be ok. This article details the benefits of 5 alternative methods and provides step-by-step instructions to quickly set these up.įuture-proof your spreadsheet's user-interface These problems may seem trivial at first but they grow into larger problems as your spreadsheet grows and more people start to use it.ģ0 years later, the VBA toolbox hasn’t changed much but fortunately Microsoft have provided more elegant options to trigger macros that are not included in the toolbox. You cannot also add hover comments to these buttons when they are used in spreadsheets.If you lock the buttons position then they can move away from the relevant part of the spreadsheet.If rows are hidden their height can reduce to 0 and disappear. These buttons move with the cells if their position is not locked.On certain displays the buttons text changes size when clicked.Very limited formatting options available.As this toolbox was a hit, it has changed very little over the last 30 years and looks very similar to what is available in Excel's developer tab today.Īlthough the old-school command buttons are still the most popular option, they have the following issues:
People rapidly became familiar with Visual Basic's toolbox and command buttons were usually used to trigger macros.
0 kommentar(er)
