How to filter on readonly workbooks

Good morning Swapnilj1
The file is password protected and i had already switched on "allow users to Autofilter" but this doesnt appear to be refreshing on opening - its only reading to the rows that it previously held even though the users have added more.
The only way around this is to open it, unprotect it and switch the autofilter of and on again - obviously this isnt practical. Surely there is an easy solution? (lol)

Hi Wrathastorm,
I think you have to amend your code and include the filter range till lastrow.
Or you have to remove the filter on read-only mode and select entire data till lastrow and apply filter.
If your macro is applying filter on Master sheet then check for the range and amend it till lastrow.
Please check and revert in case of any further assistance.