ChangeFileAccess

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I made a .xls file a readonly file by making it readonly from the properties.
However, when I send this through e-mail and the user detach it from the
e-mail, it becomes writable.
So I put a code in Thisworkbook.Open

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

If I do that, when I open up the file, it changes itself to readonly but it
will ask you if I want save changes before swithcing file status. I don't
want the user to see this pop up window. Is there anyway to by pass this or
even better way to make the file readonly when the user open it?

Thank you for your help in advance.
ps. I'm using Excel 2000
.

Relevant Pages

  • How do I View & print or convert to PDF xls files without excel.
    ... How can I View & Print or convert to PDF an xls file without Excel on a ... Windows 98 computer. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • How do I open up an emailed .xls document without Excel?
    ... I don't think I have Excel on my computer. ... ..xls file I was sent. ... I do have Microsoft Works. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Excel doesnt open document by double click
    ... i don't know how it happened, but now when i double click a xls file ... Excel starts but an error says "impossible to find..." ... Prev by Date: ...
    (microsoft.public.windowsxp.help_and_support)
  • IMPORTING SHEETS
    ... I am using EXCEL 2003. ... I need to import several specific sheets ... from a certain xls file into another xls file. ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Saving Images In Excel
    ... I have a web page opened with Excel (actually it is streamed to the user from ... with the *.xls file and not only the image paths? ... Prev by Date: ...
    (microsoft.public.excel.misc)