Allow users to use autofilter but not save on protected document

[greyscale]

Hi,

I have an excel document that will be maintained by one or two users but need other users to have access to read only and use auto-filter. There needs to be restrictions for the users maintaining the spreadsheet so it has data validation. This seems to prevent me from publishing the page to the web as saving as a web page does not seem to support data validation.

I am therefore going to allow users to open the file from a network drive. i have locked down the cells and only allow users to select cells and use autofilter. The problem is that, although general users cannot change anything in the cells, they can still use autofilter and save the file which means the next person opening it is seeing a filtered view without realising it.

How can I prevent people from saving the file?

[teylyn]

Hello,

Save the file with "read only recommended", an option in the Tools > General dialog of the Save As window. Users can not just save the file, or if they do, they have to specify a different file name.

Or you could specify a "password to modify" so only people who know the password can change and save the file, all others can view only.

cheers,

[greyscale]

Thanks for your reply, Teylyn. I think the 'password to modify' option will do the job.