June 19th, 2003, 01:54 PM
How to protect files from downloading/saving
Is there a way to post an excel file on a web site so the users can open and enter info in the file while online, but not save or download it.
Alternatively, should I disable the "Save" command within excel through VBA? If so, how is this done? This will get around the issue of saving. In a sense, it will also negate the issue of downloading since users can not save.
I want the users to be able to see and enter info while online, but not save or download.
Last edited by rendezvous; June 19th, 2003 at 02:19 PM.
June 19th, 2003, 02:13 PM
i think firstly, to use the file users will need to download it in one form or another - but you can lock it up with passwords etc of course to protected what's behind the scenes. However, it's not difficult for anyone who is determined to bypass your passwords.
you don't have to do anything to stop people saving to the file - by default what they will get is a read only copy of the spreadsheet to work with.