View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eiliya@zahav.net.il is offline
external usenet poster
 
Posts: 1
Default 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.