#EXCEL 2010 PROTECT CELLS WITHOUT PROTECTING SHEET CODE#
Save the workbook if necessary within Workbook_BeforeClose to prevent the user from cancelling the Save Changes message after your code has done its work). Typically you would do this in Workbook_Open and reverse it in Workbook_BeforeClose (and you need to Ctrl+X, Ctrl+V, Shift+Del, Shift+Insert ) that you don't want used. You can use Application.OnKey to disable (or repurpose) the key combinations (e.g. Unfortunately it is not easy there are lots of individual items to deal with. The Microsoft tech support group said I should contact this IT Pro forum. I entered the question in the website below but received no feedback. The locked cells will have their formulas hidden. Select the locked cell is very important due to the large size of the worksheet. The ability to copy from the locked cell is not an absolute need but being able to Ideally, the user can copy-paste-values from that locked cell an an unlocked cell. The user needs to be able to select locked cells. Allow ONLY copy/paste value from any cell to any unlocked cell. This is necessary to maintain the worksheet/workbook integrity when multiple users have access to it.Ģ. I wish to block a user from changing the formatting or pasting a formula in an unlocked cell via copy orĬut and paste. The goal is to allow a user to have the capability to type in data or copy-paste-values only in the unlocked cells. I need to be able to select via a macro or some other way the restrictions listed below on copy/cut/paste.
0 kommentar(er)
