View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default cannot remove read-only from a file

Try:

ActiveWorkbook.ChangeFileAccess 2
__________________________________________________ _______________________


"MAD" wrote in message
...
Files in Excel 2003 are saved to a disk as read-only. I cannot remove it
as
the
command is not checked. I thought it might work to unprotect the
worksheet.
However, this command is not available. Changing the file name doesn't
seem
to
work either.