syntax of changing file attributes

M

M K W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Transfer files & change file attributes with VBA ? 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Team Frame Fill and Arrows 0
Cannot save macro spreadsheet due to ReadOnly = True 1
Open WB 3
Save file as Read-Only 3
Issue with ExportAsFixedFormat PDF (and solution) 2

Top