Hello everyone!
I'm currently working on a sheet that, after exporting, should be protected (only specific cells allow editing) and at the same time should allow the user to use AutoFilters for sorting etc.

Now, when I set the sheet to protected

the AutoFilters

are not usable anymore (do not react on clicking on them).

On this page
(Sorry, I'm not allowed to post a link as new user)
they say that there is an option to allow AutoFilter while setting up the protection or, as in older versions, a vba command for allowing them.

How is this done with EasyXLS?

I couldn't find any hint in the docu...

Greetings
Manveru

Hi Manveru,
EasyXLS preserves macros for .xls files. Therefore, you can create an .xls template having your macro, load this file and then add your data.

Hi oana

Storing an Excel template on the server was admittedly not the answer I hoped for but is certainly a possibility.

Thank you.
Manveru

You are very welcome Manveru.