Is there a way to only protect a range of cells in a worksheet so the user doesn't enter data or info in these cells? Most of the worksheet will be unprotected but part of it won't. For example, data that is unprotected is all of the worksheet except D42 - AY43. So if the user tries to type anything
into D42 - AY43 it will not enter or will send a message box back saying "Do not enter in these cells, they're protected".
Could someone send an example or explain how to do this?
Thank you.
CC
Bookmarks