ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   cannot remove read-only from a file (https://www.excelbanter.com/excel-worksheet-functions/149166-cannot-remove-read-only-file.html)

mad

cannot remove read-only from a file
 
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.

Vasant Nanavati

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.





All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com