If you want give your user the ability to delete the rows, you have to make sure there is no locked cells on this row. We are really sorry about the inconvenience, in this kind of scenario, you might won't able to achieve your request via Protect Sheet. Ideally this should allow the user to have the excel sheet with user access as i described above, but still it does not.Ī solution to the above will be of great support. Under the title "allow users of this worksheet to: "- have ticked (checked) all the options expecting the first option ->Select Locked cells
DELETE WORKSHEET MICROSOFT DYNAMICS RMS PASSWORD
then to Review tab->Protect sheet->entered password to protect the sheetģ. Then selected the cells that i wanted to lock them and right click->format cells->protection tab->checked the lockedĢ. Selected the complete worksheet- Unlocked all the cells. To have the above working, i already did the following.ġ. as i said earlier, i do not want to use a Macro to perform this. At the same time, i do not want to share the password to unprotect the workbook.Ĥ. At the same time, i want to allow my users to copy ROW 5 and insert the copied rows above ROW 3 (this scenario comes when they wanted to insert one more line item - if they had forgotten to key in earlier.)ģ. I do not want my users to edit or select the data in the cells that falls under the column - F, H, I, J (to prevent them from accidental deletion or alteration of the formulas)Ģ. However, my problem still exists.Ĭonsider i have a costing sheet for a project (with 50 rows of items) in which each row has cells that contains formulas referring to other sheets within the same workbook.ġ.
DELETE WORKSHEET MICROSOFT DYNAMICS RMS FREE
Have you checked my suggestion? Feel free to post back if you still have any concern.
0 kommentar(er)
