Forum Discussion
Search box formular issue
See the attached version. It is now a macro-enabled workbook (*.xlsm). You'll have to allow macros when you open it.
To view the code, right-click the sheet tab and select 'View Code' from the context menu.
Enabling Marco stop the excel sheet from saving in Onedrive.
I've had to disable Macro in all my spreadsheets to be able to "Auto Save" in Onedrive. I use Onedrive for all my files. I've had to go back to a previous version of this spreadsheet because even though I have gone into settings and disabled Marco it still won't Auto Save. This stuff is very frustrating as I don't understand the process fully, very complicated.....
Here is a version that doesn't use VBA. The search box and filtered range are now on another sheet.
It won't work in the online version of Excel since ActiveX controls do not work there.