Forum Discussion
Search box formular issue
Good morning guys, I have created a "Search Box" in my excel worksheet by coping a video of "How to add a search box in Excel" but I must have something wrong in the formular as it's not searching th...
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.