Forum Discussion
Solved
Excel 2016 creating button functions without using VBA / Macros
Hello I am creating an excel document in 2016 and need to use buuttons to trigger some functions. THis is goingto be housed in Sharepoint and becasue of this and ourr ICT restrictionson macros ...
A button on a worksheet can only execute VBA code, so that's out.
You can add the Clear All Filters button to the Quick Access Toolbar for that specific workbook, so it will be available to everyone who opens the workbook:
- Click the dropdown arrow on the right hand side of the Quick Access Toolbar.
- Select 'More Commands...' from the dropdown menu.
- Select the active workbook instead of 'For all documents (default)' from the Customize Quick Access Toolbar dropdown in the upper right corner.
- Select 'Data Tab' (or 'All Commands') from the 'Choose commands from' dropdown.
- Select 'Clear All Filters'.
- Click 'Add >>'
- If desired, use the up and down arrow buttons on the right to move the 'Clear All Filters' button to the desired position.
- Click OK.
Hi Stuart,
In the Active Controls the toggle button can be linked to a cell to give you a true/false entry in the cell. Aside from a formula giving an answer when true and a blank when false, there is no way to make a formula perform "tasks" of a functional nature without macros. Hans is correct.