Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting an excel file to read-only
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting an excel file to read-only
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. wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting everyone to read ony | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
How do i remove READ ONLY setting on a file? | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel |