Well, with a little bit of VBA code we can achieve a more permanent scroll restriction.Ģ. Now then, unfortunately this isn’t a persistent feature and is reset when you save your file, close it then reopen. ![]() In the properties window enter the scroll area you want, this has to be entered manually (typed) in this example its B2:D10Īfter you have done this, you can then only scroll those few cells and cannot activate anything outside that area. First of all you need to make sure the Developer Tab is visible. It’s really easy to do this and can control user access to the cells you choose. ![]() Sometimes you may want to limit the access of a user to a particular range of cells in a worksheet, for example you may have a worksheet set up that only a certain range can be modified or activated -perhaps data entry cells or formula cells.
0 Comments
Leave a Reply. |