Forum Discussion
How to get Excel to automatically re-apply a filter when my table changes?
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
Terrific Sergei. You are a star. Does exactly what I wanted.
I have a question though. I have always shied away from using VBA macros as they seem to be a security risk and other users of my workbook will be put off from accessing it. Is that a problem with this as well?
Many, many thanks, Ian
Ian, you are welcome.
In this case that's quite simple code which you enter yourselves, thus that's safe. However, if you share workbook, other people could refuse to work with macro-enabled workbook. In organization ITS could test the workbook and give okay to use it. Or ITS won't to waste time testing each macro users bring, in such case they simply prohibit to use any macro. Or ITS trusts to protecting software installed within organization, they have regular backups of everything and allow users to use practically everything.
Approximately the same with individuals. I don't know how to prove them this or that macro-enabled file is safe. Security is always in conflict with usability, the only question is how to find the compromise.
Sergei, once again, many thanks for your response which I read with great interest.
Unfortunately, it confirmed my fears. My situation is that I am lone researcher developing a new mathematical model of virus transmission which I plan to publish. In my research paper I hope to provide a link to a public online version of my spreadsheet so that readers can see live plots of the transmission dynamics according to the parameters they select, which would require the filter to be re-applied. However, readers will not open a spreadsheet that is flagged as a security risk. Please can you suggest a method of doing this that would avoid it being a security risk. Frankly, I cannot see how an online spreadsheet can be a security risk but I admit to being very ignorant about online spreadsheets.