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 Did you solve this problem?
Another method of getting around the restriction on macros\VBA in the workbook would be to create an Excel Add-in and have the macros check for a particular feature that you insert into the workbook and only run if that feature is present.