Hello,
I have office 365 at work and we have a file that is shared and usually open in a browser like edge. Wondering if there is anyway to automate this below
When i open the file i want to clear the applied filters someone might have set if they are in the file already change this for my view only (Clear the filters in User only view not everyone view) and find the next available row as we find it hard having to scroll down through so much data just to add new data every time we use it.
Also would the script only run in the browser it was added to or is it added to the file itself so anyone who opens the file that code would run?
Thank you for any help much appreciated as normally i would do this in VBA but not sure if VBA works in a browser excel file.
Bookmarks