Needing to create a single worksheet, or an entire workbook, where you do not want other users to be able to make changes other than within a restricted area? Restricting editing in worksheets and workbooks is the best way to protect your key data and calculations from being over-typed, or worse, deleted. The user must enter the correct password in order to be able to edit that range of cells. This is a very useful tool for sheets that need to have multiple people enter different data on it. This way, one person’s work will not be accidentally or intentionally altered by another person who uses the workbook for other reasons.
how can i get allow users to edit ranges option in VBA? for particular user – Manu Mohan Mar 16 '17 at 12:18 A user is allowed to edit a sheet if the sheet is unprotected. So, if you want to implement that in VBA then you could use Worksheets("Example_sheet").Unprotect "somepassword" . I protect the worksheet and save it on the server after enabling sharing. Once shared, the 'allow users to edit range' icon is disabled. e. when multiple users connect to the sheet, the one who gets in first can access the sheet and make changes in the fields under password protection. Feb 01, 2017 · To activate worksheet protection. Do either of the following to open the Protect Sheet dialog box: On the Review tab, in the Changes group, click Protect Sheet.. If the Allow Users To Edit Ranges dialog box is open, click the Protect Sheet button in that dialog box.