Forum Discussion
Excel 2016 creating button functions without using VBA / 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.
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.
Thankyou very much for confirming what I was starting to accept.
I have done the customised bar and it seems to work acceptably however there is no way of making the button clear to the inexperienced user (this is why I wanted to use Big coloured buttons.)
I was hoping to have this spreadsheet work direct of the sharepoint so the users didnt have to download it (as there are monthly updates that they may miss)
As there are other functions I want on this workbook I know won't work without VBA
I am looking at allowing the user to download and have a macro run that check the version (date) and update and save the the file if necessary when they open the document (this could be a big task)
but it will get aroud the fact that sharepoint doesn't like Macro files
THankyou for your help