Looking for the method of applying limited restriction to cells
Asked By
0 points
N/A
Posted on - 05/26/2015
I am looking for help in finding a way to restrict the user of excel to only edit the text in the cells but retain formatting. The user can update his name, correct spelling etc buy should not change background color or font size and font. How to control these? I am using Microsoft 2010 Excel in compatibility mode. If you can share me snapshots of the controls or at least the steps it will be of great help. One more information is that th contents what user enters will get updated automatically in other sheets of same work book which will be password protected. Thank you
