How to filter on readonly workbooks

I have a "master" workbook that multiple users continually import into (via a macro) from their own individual workbooks, for this reason the master file needs to be available all the times.

I have written a macro that allows users to open the "master" readonly to enable them to spend time in it without disrupting other users who are trying to import data. However they need to be able to filter in the readonly version of the workbook - is this possible? I have spent the last couple of hours searching different forums and cant find an answer. Please help!

Cheers for the reply. The file status is set by the IT dept, some people have readonly access, others have readwrite. Sometimes the people with readwrite want to open the file readonly, which is why i wrote a macro.
But really the issue is that if i save the file with filters on and then others add new rows the autofilter isnt refreshing to include the number of rows. Hope i have explained this clearly, the file is huge (16000 rows and growing) so staff need the autofilter to search for specific data.

Hi Wrathstorm,
is your original file is password protected?
If you have the password or read-write option then you have to unprotect the sheet and has to tick ("allow all user of this worksheet to") Use Autofilter.
This will help all other users to use autofilter even if the file is in read only mode.

Thanks & Regards
Swapnilj1

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.

Hi Wrathastorm,

If you use a form button and mount the following macro on it (Obviously change the criteria etc. to what you want it to be) then you can advanced filter using that button and an input field for the document.

Please Login or Register  to view this content.

Regards

Danny

Cheers everybody
Sorry for the delay replying, sorted now thanks