You can check the file properties by right clicking on the file and choosing properties. To enter the visual basic editor press altf11.
In the save as dialog box.
How to make an excel file read only for some users.
In the image above select a folder where you want to save your excel file.
Set the file to read only with a macro.
I have an excel file that all my colleagues must have read access but only a few may have write access.
Now i want to make this file read only.
If the read only attribute is checked you can uncheck it and click ok.
I tried to introduce in workbookopen a procedure to test user and depending on it to decide how the file to be opened.
Select the save as option from the menu and click it.
By using a macro it is possible to set the file to read only when the file is opened.
Are the file properties set to read only.
I learned that does not work directly so i tried to access an add in that has a procedure that changes the readonly status.
Go to the file tab and select save as.
Select thisworkbook for the file you wish to make read only.
In the password to modify box enter a password and click ok.
You can have excel make a spreadsheet in read only format for others so that people can read its contents but not edit them or you can enforce other content restrictions.
The save as dialogue box will pop up.
The user must open the file as read only unless they have the password.
Navigate to the bottom of the box and find the tools option just next to the save button.
The first step in how to make a file read only is to enable the setting.
How to make an excel spreadsheet read only in office 2016 posted by darren march 4 2016 in office when you share one excel workbookspreadsheet with others you may do not want the spreadsheet to be modified arbitrarily by unauthorized persons.
Click on the tools dropdown at the bottom of the save as dialog box.
After selecting a folder you will get the save as dialog box as the picture below.
If you only want to recommend users to open the excel file as read only without protecting it.
Click on the tools button and click general options.
On the file tab click save as.
To do so click the.
Open the file at first and try to save it using the option save as.
Heres a step by step guide on how to add a password to make your excel workbook read only.
The content is in protected view.
Select general options from the list.
Open the workbook and click the file option.
No comments:
Post a Comment