ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   syntax of changing file attributes (https://www.excelbanter.com/excel-programming/275316-syntax-changing-file-attributes.html)

M K W

syntax of changing file attributes
 
Hello,
I set the attributes of an Excel file to Read-only, what is the VBA syntax
to remove that attribute, save the workbook and re-set it to Read-only
again. I tried

ActiveWorkbook.ReadOnlyRecommended = True

either this is not the correct syntax, or I am not using it in the correct
way.

any help would be highly appreciated




All times are GMT +1. The time now is 10:23 AM.

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