setting an excel file to read-only

[eiliya]

hi.

how can i save an excel file to be read-only?, i have used the SaveAs
meathod with the ReadOnlyRecommended property set to true
but when i open this file i get a message box that allows we to choose
if the file will be read-only or not.

how can i keep this file read-only all the time? i use vb6 on win2k and
with office 2k and the file the user is opening is a backup file that i
created, the use of this file is if the user wants to see the original
report he can view the file but i want to prevent him from changing the
backup file and thinking that the data in the DB has changed as well.
thanks in advance
gil eiliya.

 

[Dave Peterson]

On that same dialog where you specified read-only recommended, you can specify a
"password to modify".

If the user doesn't have this password, they can only open it readonly.

There's a password to open that you probably don't want to use (in this
situation).

But keep a copy.

The user could open it, change it, save it as a new name, delete the old
version, and replace it with the changed version.

If you really want to stop the users from changing it, you could ask your IT
folks for a share that only you have write access to. But allow others to read
files there.